Just to add to Mike's response...

VBA's IsNumeric is very forgiving. If a string looks a number, then VBA's
IsNumeric will give you a true.

Excel's =isnumber() is much more stringent:

msgbox isnumeric("1E5")
msgbox application.isnumber("1E5")

Noob McKnownowt wrote:

hey chaps,

just a quick question i am trying to write a VBA macro and i was just
wondering if there was any way i could identify a cell if its content is a
number:

e.g.

if cell.value = isanumber then
do this
else
do this
end if

any help would be very much appreciated

the noob

--

Dave Peterson