When run the value of ColDay1 is 0. Should the datatype for ColDay1 be different?
Dim ColDayName As Variant
Dim ColDay1 As Integer
ColDayName = Array(12, 19, 24)
Asked
Active
Viewed 20 times
0
Scott Craner
- 148,073
- 10
- 49
- 81
S Webster
- 7
- 3
-
it is `0` till you assign a value. `Dim` does not assign a value, it declares the variable. – Scott Craner Oct 26 '20 at 22:29
-
and Integer will work fine for column but `Long` is the preferred method of many here. – Scott Craner Oct 26 '20 at 22:30
-
^ Not only preferred, but better, see [this](https://stackoverflow.com/questions/26409117/why-use-integer-instead-of-long). – BigBen Oct 26 '20 at 22:51