Excel built-in function

[mlai08]

Hi,

I tried to use the Excel function ISNUMBER in marco coding but got a compile error: sub or function not defined.

e.g.

If IsNumber(ActiveCell.Value) Then
do something
else
do othertning
end if

Does anyone know why this built-in function works in the spreadsheet but not in the marco codes?

Thanks

 

[boblarson]

I think you need to use

If WorksheetFunction.IsNumber(ActiveCell.Value) Then...

instead.

 

[mlai08]

Boblarson,

Thanks for enlightening me. I know it should not be something complicated.

 

[chergh]

The equivalent VBA function is 'isnumeric'