Hello, I am trying to do a calculation in VBA that loops through cells and performs a calculation. However it keeps throwing an overflow error when it tries to divide the first two values. This is the error line and below is the functionAny thoughts as to why?
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by jonboy6257; 12-01-2013 at 05:27 PM. Reason: Solved
It is probably one of the denominator figure is 0. You can not divide a number by zero.
I changed the direction of the division simple and got the division by zero error. I then changed the code to look like the following to account for the 0.
I am still getting the error. Is there another way U should check for 0 and skip it if so?Please Login or Register to view this content.
By zero, I mean including empty and blank cells.
Yes, you can include an if statement to skip that cell if it is zero.
I realized I just left the value off in the second part of the AND statement so it wasn't checking what the second part was equal too. It seems to working correctly now. Thanks for the quick responses!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks