Thread: Why is this a number?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave F.[_5_] Dave F.[_5_] is offline
external usenet poster
  
Posts: 4
Default Why is this a number?
Hi
I'm using VBA 6.3

If I pass 45- to this:

If IsNumeric(OffsetNo) = False Then
...

it returns True.

1) Why?

2) How do I prevent this happening?

Thanks in Advance.


Reply With QuoteReply With Quote