Identifying Error cells

[cadas]

Hi, sencond attempt properly formatted this time

In the macro I am writing i create a data table using data from each worksheet. However, i need to delete rows which contain data from sheets that have been deleted.

When a sheet is deleted you get a 'ref' error in the cell ie. "=#Ref!C2"

I assumed the easiest way would be to use the sub I have for identifying empty rows, but use it to identify error cells.

Please Login or Register  to view this content.

I though this would be shorter than trying to incorporate a 'sheet_delete' event macro. The problem is if there are no error cells, this deletes everything and then replaces cell with good content with 'FALSE'



Any ideas, thanks

[DonkeyOte]

If the original errors are in formulae present in Column B then you could use:

Please Login or Register  to view this content.