Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 1st 05, 06:57 AM
KymY
 
Posts: n/a
Default Function to List an Excel Workbook's Sheet Names

How can I print this information (in File Properties Contents) or copy-paste
the workbook's list of Sheets Contained (by name) into a new worksheet - I
have a workbook with 50 odd sheets in it (1 for each employee under our
voluntary benefits plan) and I just want to copy a list of these (row-by-row)
into another worksheet, to send each e/ee a mail-merged letter outlining
proposed changes to the plan

(From - 01April2005 (& no fooling!))

  #2   Report Post  
Old April 1st 05, 10:47 AM
Peter Rooney
 
Posts: n/a
Default

KymY

How about this bit of VBA?

Sub ASheetList()
Dim Count As Integer
For Count = 1 To ActiveWorkbook.Sheets.Count
Range("A1").Offset(Count, 0).Formula =
ActiveWorkbook.Sheets(Count).Name
Next
End Sub

Hope this helps

Pete

"KymY" wrote:

How can I print this information (in File Properties Contents) or copy-paste
the workbook's list of Sheets Contained (by name) into a new worksheet - I
have a workbook with 50 odd sheets in it (1 for each employee under our
voluntary benefits plan) and I just want to copy a list of these (row-by-row)
into another worksheet, to send each e/ee a mail-merged letter outlining
proposed changes to the plan

(From - 01April2005 (& no fooling!))



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make an excel worksheet (sheet 2) open w/ the cursor located in t. animated text in excel worksheet Excel Discussion (Misc queries) 0 February 10th 05 10:29 PM
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 12:02 AM
Tab list position in Excel RRe Excel Discussion (Misc queries) 1 January 9th 05 12:12 AM
Locking Sheet names in formulas O'C Excel Worksheet Functions 2 December 16th 04 06:31 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017