Splendid IsDate() behaviour!
Caught out by VBA this morning...
Returns "True". However,
also returns True. The same happens with 0A,1A,2A,3A, ... to 9A. You can have any number of spaces after the initial string.
To get around it I changed the application code, which is formatting and pasting large arrays onto worksheets.
Any other IsDate() problems I should be aware of?
"Splendid" ? Glad you like it
Here are some other examples of IsDate = True
"1305/03", "1-0", "9999-12"
Does the same in VB6
But, apparently fixed in VB.NET