if isnumeric(value) then
perform calculation
End if

--
Regards,
Tom Ogilvy

"jonx - ExcelForums.com" wrote in
message ...
How would I check to see if a value is an integer? Is there such a
function?

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

I was hoping to do something like this:

If value is integer then
perform calculation
end if

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