Someone recently indicated to me that:
Dim i, LastRow, LastNum As Long
...was shorthand for:
Dim i As Long, LastRow As Long, LastNum As Long
Before that I had always used the latter, and as my formulas all continue to operate as expected when I used the shorthand, I surmised their suggestion was correct.
Prior to that I had always thought that declaring JUST a variable name mean Variant, but this testing made me believe otherwise... (literally just days ago).
So I was right in my original understanding, I DO need to declare in longhand? Why would my numerical(s) variable continue to function with no issues? Usually I get error messages when I use the wrong TYPE of variable.
Bookmarks