Hi all

I find myself regularly performing a couple of tasks which should not be too
hard to automate. The wheel has probably already been invented, and if
available for download I would appreciate a link. Otherwise it probably
only requires a few lines of VBA, and would appreciate that:

1) I want a macro the execution of which will create a new worksheet within
the active workbook and, in that (new) worksheet, list all instances of
#REF! error messages found anywhere in the workbook. I am really interested
in searching used cells, as I can use NameManager to identify errors in
names.

2) I want a macro the execution of which will create a new worksheet within
the active workbook and, in that (new) worksheet, list all worksheets in the
active workbook that contain cells that are dependent on the active
worksheet. (the purpose of this is to be run preparatory to deleting the
active worksheet in order to review potential problems that might arise from
the generation of #REF! error messages in dependent worksheets).

Thanks

--
Return email address is not as DEEP as it appears