software

A couple years (1 or 2) I ran into a macro that would enumerate work sheets
in a workbook. The macro listed all of the formulas used in a worksheet in
a separate worksheet attached to the end and would do that for all of the
worksheets. Anyone remember this macro I thought an MVP had this on one of
their personal sites but I can no longer find it (or was it a previous
version of excel)?

--
WARNING!

This message may contain privileged or confidential information and is
intended only for the individual named; copies should not be disseminated
without advanced explicit consent of the sender. If you are not the named
addressee you should not disseminate, distribute or copy this email. Please
notify the sender immediately by email if you have received this email by
mistake and delete this email from your system. Email transmissions cannot
be guaranteed to be secured or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses and/or worms. The sender therefore does not accept any
liability for any viruses, worms, errors or omissions in the contents of
this message, which may or may not arise. (Means don't believe anything you
read, I guess?)

SYSTEM: Windows XP Pro 5.1.2600; Office XP Office 10 2002; Works 8
Maybe this is what you were thinking of

www.j-walk.com/ss/excel/tips/tip37.htm--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Philippe L. Balmannoquot; gt; wrote in message
news:Hzduf.1296$jR.1023@fed1read01...
gt; A couple years (1 or 2) I ran into a macro that would enumerate work
sheets
gt; in a workbook. The macro listed all of the formulas used in a worksheet
in
gt; a separate worksheet attached to the end and would do that for all of the
gt; worksheets. Anyone remember this macro I thought an MVP had this on one
of
gt; their personal sites but I can no longer find it (or was it a previous
gt; version of excel)?
gt;
gt; --
gt; WARNING!
gt;
gt; This message may contain privileged or confidential information and is
gt; intended only for the individual named; copies should not be disseminated
gt; without advanced explicit consent of the sender. If you are not the named
gt; addressee you should not disseminate, distribute or copy this email.
Please
gt; notify the sender immediately by email if you have received this email by
gt; mistake and delete this email from your system. Email transmissions cannot
gt; be guaranteed to be secured or error-free as information could be
gt; intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
gt; contain viruses and/or worms. The sender therefore does not accept any
gt; liability for any viruses, worms, errors or omissions in the contents of
gt; this message, which may or may not arise. (Means don't believe anything
you
gt; read, I guess?)
gt;
gt; SYSTEM: Windows XP Pro 5.1.2600; Office XP Office 10 2002; Works 8
gt;
gt;
quot;Philippe L. Balmannoquot; wrote
gt; A couple years (1 or 2) I ran into a macro that would
gt; enumerate work sheets in a workbook.
gt; The macro listed all of the formulas used in a worksheet in
gt; a separate worksheet attached to the end and would do that for all of the
gt; worksheets. Anyone remember this macro I thought
gt; an MVP had this on one of their personal sites
gt; but I can no longer find it (or was it a previous version of excel)?

Another thought .. perhaps JE McGimpsey's
Sub ListFormulasInWorkbook() at:
www.mcgimpsey.com/excel/listfunctions.html
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
Thank you,

JE McGimpsey's was the one that fit the most as multiple worksheets/tabs
were enumerated. John Walkenbach's VBA is good for single sheet/tab
workbooks. Both are appreciated thanks again.quot;Philippe L. Balmannoquot; gt; wrote in message
news:Hzduf.1296$jR.1023@fed1read01...
gt;A couple years (1 or 2) I ran into a macro that would enumerate work
gt;sheets in a workbook. The macro listed all of the formulas used in a
gt;worksheet in a separate worksheet attached to the end and would do that for
gt;all of the worksheets. Anyone remember this macro I thought an MVP had
gt;this on one of their personal sites but I can no longer find it (or was it
gt;a previous version of excel)?
gt;
gt; --
gt; WARNING!
gt;
gt; This message may contain privileged or confidential information and is
gt; intended only for the individual named; copies should not be disseminated
gt; without advanced explicit consent of the sender. If you are not the named
gt; addressee you should not disseminate, distribute or copy this email.
gt; Please notify the sender immediately by email if you have received this
gt; email by mistake and delete this email from your system. Email
gt; transmissions cannot be guaranteed to be secured or error-free as
gt; information could be intercepted, corrupted, lost, destroyed, arrive late
gt; or incomplete, or contain viruses and/or worms. The sender therefore does
gt; not accept any liability for any viruses, worms, errors or omissions in
gt; the contents of this message, which may or may not arise. (Means don't
gt; believe anything you read, I guess?)
gt;
gt; SYSTEM: Windows XP Pro 5.1.2600; Office XP Office 10 2002; Works 8
gt;
You're welcome !
(from us)
--
Rgds
Max
xl 97
---
Singapore, GMT 8
xdemechanik
savefile.com/projects/236895
--
quot;Philippe L. Balmannoquot; gt; wrote in message
news:ByEuf.5666$jR.3969@fed1read01...
gt; Thank you,
gt;
gt; JE McGimpsey's was the one that fit the most as multiple worksheets/tabs
gt; were enumerated. John Walkenbach's VBA is good for single sheet/tab
gt; workbooks. Both are appreciated thanks again.