Inventory a WorkBook

C

CLR

Hi All......

If someone would be so kind, please tell me how I might obtain a count of
all the sheets in a Workbook, and then create a new sheet called
SheetInventory and place a list of all the SheetNames thereon.......

TIA
Vaya con Dios,
Chuck, CABGx3
 
T

Tom Ogilvy

Dim sh as Object
Dim i as Long
worksheets.Add After:=sheets(sheets.count)
Activesheet.Name = "SheetInventory"
i = 0
for each sh in sheets
i = i + 1
cells(i,1).Value = sh.Name
Next
magbox "Total Sheet Count is: " & sheets.count
 
C

CLR

It works "finer than frog hair", Tom.........

Many Thank-you's

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top