Ignore Text, function only for numerical values

[Guest]

Hi I'm using a loop function to evaluate the value in a cell and perform a
desired function, then moves on to the next row until it reaches the last row
in my sheet.

My evalution criteria is (but I need help fixing it):
if activecell <>0 Or activecell="" then
Something
else
SomethingElse
End if

Here my question:
How can I change my if statement to only do Something if the value in the
cell is a number (ignore textual entries) and is different than 0 or is empty

Thanks for the help

Daniel

 

[Tom Ogilvy]

My evalution criteria is (but I need help fixing it):
if activecell <>0 Or activecell="" then
Something
else
if isnumeric(activeCell) then
if activeCell.Text <> "0" then
SomethingElse
end if
end if
End if

 

[Ed]

Check out IsNumeric.

Ed