Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable names in a loop
Thanks for your help with solving the userform controls naming when using a
loop. I also have 5 public variables (as date) called time1, time2, time3, time4 and time5. They are used in the following code. They used to work fine when i did it 5 separate times but in order to minimise code i tried, For Box = 5 to 1 step -1 Cells(riderCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1) = WorksheetFunction.Text(("Time" & box), "[hh]:mm:ss") I'm guessing I need some form of code to let it know that "time" & 5 is a variable name not the text time5. I am now starting to understand why I thought it was safer to have 5 times as much code. I'm sure it's simple but can anybody help me. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop with variable name? | Excel Discussion (Misc queries) | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Loop with variable | Excel Programming | |||
Loop through Worksheet Names | Excel Programming | |||
Loop using cell names | Excel Programming |