Ignore Text, function only for numerical values
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
|