Identify rows that have generated errors through their calculations
Posted on 2003-12-04
I have columns B through IV, rows 4 -45
all of the results for these fields are generated through calculations. Some experience errors and result in #Value! or #DIV/0! I don't want to change the numbers being generated and know why those errors occur. But I would like to run a macro that woudl go through all the rows and evrytime it runs into one that generated an error change it to blank, without it removing the calculation that still sits in the cell - is this possible?