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

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

good man

cheers pal

noob

"Mike H" wrote:

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

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