Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey guys I have 70 variables. Each one of these variables
is equal to a DataField in a PivotTable. I am creating a variable for each field so I can programmatically control them from a listbox. Now because I have 70 fields I need 70 variables. What should I set the variable to and how should I do it with the least amount of code. Many times I have seen the following for example: Dim ExmplVariable as Object, ExmplVariable2, ExmplVariable3 Can I do this all on one line and do I have to use "as object" for each variable or can I do it only once? Thanks Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Variables in VBA | Excel Discussion (Misc queries) | |||
Using variables . . . | Excel Discussion (Misc queries) | |||
SUM IF and two variables | Excel Worksheet Functions | |||
How to see all variables? | Excel Programming |