Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inventory a WorkBook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inventory a WorkBook
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 -- Regards, Tom Ogilvy "CLR" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory and sales formula within a workbook. | Setting up and Configuration of Excel | |||
Inventory | Excel Worksheet Functions | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Inventory Workbook - automated entry worksheet??? | Excel Programming | |||
Search Page for Inventory Workbook | Excel Programming |