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