About Us

BAM100

Any way to do this? Sorry for such a basic question.

Thanks.

Richard

Create a module and put this code in it. Run the macro.

Sub PrintWorksheets()
Dim wks As Worksheet
Dim rng As Range

Set rng = Range("a1")

For Each wks In Worksheets
rng.Value = wks.Name
Set rng = rng.Offset(1, 0)
Next wks
End Sub

"BAM100" wrote:

Any way to do this? Sorry for such a basic question.

Thanks.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print list of names of all sheets in a workbook	Jo	Excel Discussion (Misc queries)	1	September 24th 09 05:00 PM
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET	r.kordahi	Excel Discussion (Misc queries)	2	January 3rd 09 08:10 AM
Print list of ws names	Joanne	New Users to Excel	3	October 8th 07 03:16 PM
HOW DO I PRINT A LIST OF WORKSHEET TITLES FOR A SPECIFIC WORKBOOK	beyondthevail	Excel Discussion (Misc queries)	1	August 30th 06 04:58 PM
How do I print a list of worksheet tab names in a workbook	Clif	Excel Worksheet Functions	3	March 2nd 05 09:38 PM

Menu

About Us