Hello,
I feel like I am so close to this but I think I am not adept enough at macros to get it right enough to work. And, I have searched high and low and found everything but what I am looking for. I also tried to use the macro recorder but as I have learned it won't work for this. I know how to do it manually through "Find" however I will not be using this spreadsheet and the people who will be need as few steps as possible.
I need a macro that will find all #REF errors in range A1:L756 and clear the cells. I don't want the cells deleted but I am fine with the formatting, contents, etc all cleared out.
Thank you very much for your help!
Mandy
I feel like I am so close to this but I think I am not adept enough at macros to get it right enough to work. And, I have searched high and low and found everything but what I am looking for. I also tried to use the macro recorder but as I have learned it won't work for this. I know how to do it manually through "Find" however I will not be using this spreadsheet and the people who will be need as few steps as possible.
I need a macro that will find all #REF errors in range A1:L756 and clear the cells. I don't want the cells deleted but I am fine with the formatting, contents, etc all cleared out.
Thank you very much for your help!
Mandy