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

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

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