View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jonx - ExcelForums.com jonx - ExcelForums.com is offline
external usenet poster
 
Posts: 1
Default Checking if value is a number

How would I check to see if a value is an integer? Is there such
function

I am trying to grab values off a worksheet and perform calculations t
them, the only problem is that sometimes these values are "N/A" whic
is a string. Since we can't perform calculations on strings, m
program will crash

I was hoping to do something like this:

If value is integer the
perform calculatio
end i

how would i do this
--------
Message sent via www.excelforums.com