Code to Hunt Linked Cells
Abdul, this works great - thanks. You mention press "Find
All." I'm using Excel 2000. This option does not show in
the "Find" dialog box. Is there something else I can do
not have to "Find Next"?
-----Original Message-----
without using VBA you can do this ..
EditFind and in findWhat box type ! and press Find All
will give you a list of all linked cell reference
Abdul Salam
-----Original Message-----
This is an ongoing thread that I have updated (changed
my
idea...).
Want to put code in my "Personal Macro Workbook", attach
it to a menu button: when user clicks the button, all
cells in the active worksheet having links to other
cells
(wherever located) are highlighted. An alternative
could
be to make a list. If the cell already has a background
color, could the background color be restored upon
clicking the same button, or a second button. If not,
can
exit without a save.
The objective is to know where all links are at a single
glance - with the click of a menu button.
Any suggestions to do this more effectively is
appreciated.
Thanks, Phil
.
.
|