I'm trying to write a sub that will accept either text or a value as a parameter and have encountered some behavior I don't understand.
If I take this code:
Sub TestInput(strText As Variant)
MsgBox VarType(strText)
End Sub
and call it from the immediate window
TestInput(53)
I get...
Does anyone have a good breakdown of why you would use a class module? I'm good with the how, just not the why. Since the collection isn't static you have to read all the members back in each time the sheet is opened. How is this much different than reading an array into memory and using...
Having read the virtues of the SumProduct function I thought I'd put it to good use. My key data source is a Pivot Table connected to an OLAP data source.
The problem arises in that the data is not repeated for all the pivot fields
ie the data looks like:
Region------Store...