View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default Help appreciated

Any help please appreciated..

It seems I need to hit the command button twice in order for the code ito do
the rezisng of the range properly. (60 rows and variable number of
columns).If i hit the button only once it resets the range to something
totally different. What is wrong???


Private Sub AddParameters_Click()
Dim i As Integer
Dim EngineRange As Range
Dim Col As Integer
Dim NewEng_Range As Range


Set EngineRange = Range("Eng_Range")
i = 60
Col = 1
Do
Col = Col + 1
EngineRange.Resize(i, Col - 1).Name = "Eng_Range"

Loop Until IsEmpty(EngineRange(Col))

EngineRange.Resize(i, Col - 1).Name = "NewEng_Range"


End Sub