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