Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Variables as Strings
Is it possible to create a variable with the value being a String of a VBA
name? Var1 = whatever Var2 = "Var1" I have data in my sheet with values identical to variable names in my code. I thought this maybe one way I could reference or find those cells. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Variables as Strings
No, you can't, but perhaps you could create workbook names with that name
and store values in there. -- __________________________________ HTH Bob "JeremyJ" wrote in message ... Is it possible to create a variable with the value being a String of a VBA name? Var1 = whatever Var2 = "Var1" I have data in my sheet with values identical to variable names in my code. I thought this maybe one way I could reference or find those cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variables & strings | Excel Programming | |||
Variables in Query Strings | Excel Programming | |||
Assigning multiple text strings to variables | Excel Programming | |||
substitute strings with variables | Excel Programming | |||
Complex Text Strings|Variables | Excel Programming |