Worksheet name [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,

in sheet 1, i need to get the name of other worksheets using formulas.

thanks,

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
Copy this formula in module and run in Sheet1 all sheet's name will be copied from A1 to onward .....


Sub LISTSHEETS()

Dim ws As Worksheet
Dim x As Integer

x = 1

Sheets("Sheet1").Range("A:A").Clear

For Each ws In Worksheets

Sheets("Sheet1").Cells(x, 1) = ws.Name
x = x + 1

Next ws

End Sub
hi thanks alot for the macro which i already have...but i am looking for a function to get this data and not a macro.
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!