Help edit this code so that it loops through specific worksheets

Hi everyone, can anyone help edit this code so that it loops through specific named worksheets "A", "B", "C","D" in my workbook.

Thanks.

Please Login or Register  to view this content.

Hi Robert,

Originally Posted by Trebor76

Hi rocksan,

Are the error messages the result of existing formulas or have they been converted to values so it's just the text that's showing?

Robert

The formulas are used to do some calculation, sometimes the calculation divides by zero, thats why it results in the error. The N/A happens when the data itself is unavailable yet for calculation. Another sheets uses the calculated data, since the data is either #DIV/0 or #N/A, the whole formula fails. The macro is just a quick fix i need to clear those errors on corresponding sheets, I just want it to loop automatically, instead of finding and fixing the affected sheet manually.

The code works perfectly.

You're so helpful. Thank you very much Robert.