Caught out by VBA this morning...

VB Code:
  1. IsDate("2A")

Returns "True". However,

VB Code:
  1. IsDate("2A           ")

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?