I have a problem with the variable NewNum
NewNum is a number
with
Dim NewNum As VARIANT the MsgBox returns Zero for the count
but the StrPtr(NewNum) & Len(NewNum) work correctly
with
Dim NewNum As LONG the MsgBox returns the count correctly
but the StrPtr(NewNum) & Len(NewNum) fail
with
eliminating the defining of the variable
MsgBox returns Zero for the count then pops up two more messages boxes containing the number 4 (there are 4 blank cells in my data - coincidence?)
again, the StrPtr(NewNum) & Len(NewNum) work correctly
Please Login or Register to view this content.
Bookmarks