Hi,

I have a spreadsheet model that generates a new worksheet for each new project and then collates all the data up into a series of index pages and charts.

The problem comes when a sheet is deleted and you end up with "#ref" errors on the index pages.

In the abscence of an 'sheet_ondelete' function I have been trying to find a solution to run a macro that removes all redundant columns from the index pages.

Currently I am using 'specialcells' function to identify the function, but can only run this on startup, so to update it is necessary to close the workbook and re-open.

I have tried using the 'sheetActivate' method, but I can't resolve looping problems.

So to new idea, can I use the CVerr function to monitor a cell on the index page. So if a sheet is deleted, the cell on the index page will automatically change to "#ref" which in turn automatically gives a return under CVerr and calls the relevant cleanup macro?

Thanks