Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting Sheet Names on a list
HI!
Can anybody please tell me how to put the list of Sheet Names in a list. Like for example, in a particular cell, a list would show "Sheet1", "Sheet2", & "Sheet3". Would it be possible also, that if a new Sheet will be added, ie. "Sheet4", it would just add up on that list. That list will be then used as choices to what particular sheet I would print. The situation is, I have a table on each sheet. Same format. Sometimes, new sheet/s is/are added. Within that table, I have series of codes taking data in one row, pasting it in a form, and give print. Then, goes to the next row...and so on and so forth. Please help. Thanks a lot people of great minds..... Best regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a list of names on a sheet frm various sheets in e | Excel Discussion (Misc queries) | |||
Putting Sheet Names in a range and renaming it? | Excel Worksheet Functions | |||
Creating list of sheet names | Excel Programming | |||
Creating list of sheet names | Excel Programming | |||
VBA to insert list of sheet names | Excel Programming |