Utility required - probably already invented
 

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

Utility required - probably already invented
 

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

Utility required - probably already invented
 

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

Utility required - probably already invented
 

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

Utility required - probably already invented
 

Jack,

Well, I invented(?) something that might do part/all of what you want...

' Finds worksheet formulas on each sheet in the active workbook.
'Adds a new worksheet and lists all formulas found and their cell addresses,
' values, precedents and dependents.
' Formulas that have error values will also appear on the list.

The vba code is shown is this post...
http://makeashorterlink.com/?L5F24173B

Regards,
Jim Cone
San Francisco, USA


"Jack Sheet" wrote in message
...
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

Utility required - probably already invented
 

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

Utility required - probably already invented
 

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