enumerate sheet
 

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

enumerate sheet
 

Maybe this is what you were thinking of

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


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Philippe L. Balmanno" wrote in message
news:Hzduf.1296$jR.1023@fed1read01...
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

enumerate sheet
 

"Philippe L. Balmanno" wrote
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)?

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

enumerate sheet
 

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.


"Philippe L. Balmanno" wrote in message
news:Hzduf.1296$jR.1023@fed1read01...
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

enumerate sheet
 

You're welcome !
(from us)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Philippe L. Balmanno" wrote in message
news:ByEuf.5666$jR.3969@fed1read01...
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.