Hi,

You could do this

Set cell = Range("A1")
If IsNumeric(cell.Value) Then
'do this
MsgBox "Number"
Else
MsgBox "Not number"
'do this
End If


Mike


"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