Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to set a few variables within a loop, The loop function is for the variables specifically. I would like something to this effect ------------------------------------------------------------------------------------------------ ZoneNumber = 1 ZoneFromRow = 2 "Zone"& ZoneNumber = Cells(ZoneFromRow, 4) Do ZoneFromRow = ZoneFromRow + 1 If Cells(ZoneFromRow, 4) < "Zone" & ZoneNumber(variable) Then ZoneNumber = ZoneNumber + 1 "Zone"& ZoneNumber=Cells(ZoneFromRow, 4) End If Loop Until "Zone" & ZoneNumber = "" ------------------------------------------------------------------------------------------------ Apparently i am doing this wrong. If someone could please inform me on how to properly dimension this (these) variable(s) I would be greatly apreciative. Thanks Ironhydroxide |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting Multiple Variables with a loop | Excel Discussion (Misc queries) | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Setting a range within a loop variable for copy/paste | Excel Programming | |||
TextToColumns delimiter setting ignored w/in VB loop | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming |