Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |