How not number ?
 

Dim x As variant

x = Range("G10")

If Isnumeric(x) then msgbox "we have a number!" else msgbox "we cannot
compare this to a number!"

DM Unseen

How not number ?
 

I declared

dim x

and x is numeric in compare..
x = sheet("G10")
when G10 have a number is OK...
but if G10 is empty ??

How to make one comparation if X is not number ?

thanks

Marina

How not number ?
 

dim x as Variant
x = worksheets("sheet1").range("g10").value

if application.isnumber(x) then
msgbox "it's a number"
else
msgbox "it's not a number"
end if


Marina Limeira wrote:

I declared

dim x

and x is numeric in compare..
x = sheet("G10")
when G10 have a number is OK...
but if G10 is empty ??

How to make one comparation if X is not number ?

thanks

Marina

--

Dave Peterson