View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default 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