[mso] Re: Excel Command or VBA Code to list all Sheet names
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 8 Oct 2003 12:23:09 -0400
Hi Christine...Chad Welch wrote a great two-part article for my newsletter
on creating a Table of Contents in Excel using VBA, which should give you
exactly what you want:
Part 1:
http://personal-computer-tutor.com/abc1/v6/chad6.htm
Part 2:
http://personal-computer-tutor.com/abc2/v8/chad8.htm
Of course, since I'm not a VBA kinda gal, I do this a little
differently...what I do is click in cell A1 of each sheet and use the Name
Range feature to name that cell the same as the sheet name....then once I
have all the A1 cells named, I just go to a new sheet and Insert>Name>Paste
and click on the Paste List button and that pastes all the names into that
sheet.
Of course, Chad's way is better for some people cuz his way creates
clickable links to the pages...with my way, you have to use the Name
dropdown box to access the sheets.
Have fun :-)
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of McDonald, Christine, Ms, DCAA
Sent: Wednesday, October 08, 2003 12:05 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel Command or VBA Code to list all Sheet names
Is there an Excel command or VBA code that can be written to generate a
listing of all the sheet names in an Excel Workbook? Using Excel 2002
on Windows 2000.
Thanks,
Christine McDonald
Technical Specialist
Western Regional Office
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
