Posted: Fri Nov 14, 2008 4:29 pm Post subject: Excell Function not defined ?
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 ?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum