Anthony's VBA Forum

[ddanmcgrew]

I am writing a macro
users enters numbers in cells on "Input" workshhet.
macro grabs numbers performs math functions on them.
and loops thru approx 20 input cells
everytime this function is run some of those input cells will be empty
When it grabs an empty cell you get a division by zero error
So I need it to end the loop when it encounters the first empty cell.
Code goes like this

Do Until a >= 31
If IsNumber(worksheets("Input").Cells(a,b) = False Then
Exit Do
End If

The problem is I get an Error that "Sub, Function, or Property not defined (Error 35)"
It highlights the name of the Sub
Sub PressureTable()
and the built in excell function
IsNumber
This is a built in excell function and it automatically capatilized the I and the N in IsNumber when i typed it into the code
Why can't I use it ?

[mohan.ankur]

Try

Worksheetfunction.IsNumber

All the excel functions which are available in VBA are used with WorkSheetfunction. and the function...

Hope this helps
_________________
http://www.exceldepot.com
http://www.xlmacros.com
http://www.learnexcel.org

[ddanmcgrew]

Thanks a lot.
I am new to coding, but this is huge for me
Thanks a lot
New Structural Engineer
Dan C.