Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Value of Dynamically Created Variable
I know this is easy, but I can't figure out the syntax to use the actual value of a variable created dynamically in a For loop. See below. Any help would be appreciated. Thanks!
Dim CHT_1, CHT_2, CHT_3, CHT_4 as Integer Dim VariableName as String CHT_1 = 5 CHT_2 = 6 CHT_3 = 7 CHT_4 = 8 For i = 1 to 4 VariableName = "CHT_" + CStr(i) Can't figure out syntax to use actual value of variable name Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radio Buttons Created Dynamically | Excel Programming | |||
delete dynamically created combo box | Excel Programming | |||
How do I call a dynamically created String in a VBA Sub | Excel Programming | |||
dynamically created listbox | Excel Programming | |||
Scaling a chart that has been dynamically created in vb | Charts and Charting in Excel |