Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help would be much appreciated! | Excel Worksheet Functions | |||
Any help much appreciated | Excel Discussion (Misc queries) | |||
Can't quite get what I want with bar chart; help appreciated | Charts and Charting in Excel | |||
TAN different to a calculator? Please help would be appreciated lo | Excel Worksheet Functions | |||
Hello, again Help is appreciated | Excel Worksheet Functions |