Hello Dear Excel Help
I'm trying wrap my mind around types in VBA. Is there definitive guide or table?
For each type I need to discern uninitialized state (no value supplied that means default value) from state when default value is explicitly supplied to variable.
That means:
1a) Dim int As Integer
vs
1b) Dim int As Integer
int=0
Another problem is with arrays for each type I need to discern states:
2a) Dim int() As Integer
vs
2b) Dim int() As Integer
Redim int(1 To 10)
2c) Dim int() As Integer
Redim int(1 To 10)
int(1)=0
In 2c) I need to discer states int(1) vs int(2).
I know for Variant array I can use IsEmpty and C. Pearson gives IsArrayEmpty function which can check whether array of all types was dimensioned or not.
Bookmarks