ISNUMBER always returns Double

[hankm3]

Hello,

New to VBA in Excel. When I use the IsNumber it always returns a Double for a Number, whether it's 5, 5.01 or 500. It seems that this is always the case. Is there a work around. I'm attempting a DDE Operation from Procomm Plus to find out what's in the Active Cell.

Thanks in Advance..

Hank

 

[SkipVought]

Hi,

ISNUMBER returns TRUE or FALSE.

Your cell formatting needs to reflect the formatting that you choose.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[hankm3]

Hello,

I think I meant CellType..

Sorry... Will repost

Hank