DIm Variables
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
|