division by zero

My clients have asked for a report that tracks the % change in error rates from one month to the next for their regions. They have specifically asked that if an error decreases, the % should read with a " - " for easier viewing. For example, Region 1 went from a 9.09% error rate in February to...

I have a simple macro to loop through worksheets in a workbook and look for the last/largest ID number (Column A) in the entire workbook. This code works periodically when running and always works when stepping through in debug mode. BUT other times when running it (even in the same...

Hello, I have a VBA sub that reads some values off a worksheet, calculates some statistics and prints them into different cells. I built the workbook using Excel 2011 for Mac. At one point I am getting a runtime 11 error: "Division by zero". The line highlighted by the debugger only uses...

I am new to VBA programming and am trying to develop a simple code for RCC design. Most of the values are assigned directly from the excel sheet. I am getting this error that says "division by zero".The line within **(red) ** is highlighted while debugging. it seems there is some problem with...