IF Error Macro

[Wbdavisg01]

I'm trying to run a macro that will add an IFERROR to all formulae in an entire Excel workbook so that it will get rid of all the #ref! errors. The #ref! is happening because many of the formulae are looking for information in pivot charts that has not yet been created, which I am aware of. The macro that I am using is below and the error message is in the .png file. Any help as to what needs to be edited to get this to run properly. The desired end result is to wrap my formulas in IFERROR that returns a blank cell.
Function loopThroughRange(r As Range)

Please Login or Register  to view this content.

Function loopThroughRange.docx

[jason.b75]

I didn't evaulate your code to see if you were trying to do anything else with it as well, this will add the IFERROR function to any formula that currently returns #REF

Please Login or Register  to view this content.

I've assumed that you might have some array formulas in your workbook and that you want to leave any other errors, #VALUE!, #NUM!, #DIV/0!, #NAME? and #NULL! in place for troubleshooting purposes.

[Wbdavisg01]

I've inserted this code and it's returning an error. The yellow portion is what seems to be the issue. Did I miss something? VBA/macro newbie over here. Thanks again!


Macro Error 2.PNG

[jason.b75]

Sorry, that was my bad!

A worksheet with no errors of any kind will cause that, this will force past it. As before, this will only clear #REF! errors, all other errors will remain in place.

Please Login or Register  to view this content.