Okay so I have massive spreadsheets that have iferror statements in them to eliminate N/A errors in my sheet. Certain information shifts to different dates on different months. I used to do a find replace all in 2003 and I would hold down escape whenever it hit errors for the day that was missing info for that month. Now in 2010 as soon as I hit an error the search stops.

I am dealing with 3200 cells and 1/4th of them will error depending on what day is missing info.



Advice please