I guess because those could be external. Thanks.

--
Regards,
Tom Ogilvy

"Jack Sheet" wrote in message
...
Hi

It won't do everything that I wanted in the OP, but it will find broken
links containing eg #REF

"Tom Ogilvy" wrote in message
...
I was under the impression it only found links to external workbooks -
not
links between sheets in the same workbook. Does it work for links
within
a
workbook?

--
Regards
Tom Ogilvy

"Jack Sheet" wrote in message
...
Duh, now I feel sheepish. Already have FindLink installed but never
looked
at it beyond finding links to external workbooks.

Thanks for that.

"Tushar Mehta" wrote in
message
m...
See Bill Manville's FindLink utility
http://www.oaltd.co.uk/MVP/MVPPage.asp#BillManville

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , mind-the-
says...
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