| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Macro to Collect Multiple Worksheet Names
I need a macro to collect the names of every worksheet in a workbook such
that the names are in adjacent cells in one worksheet. The number of worksheets can vary and ideally I don't want to collect the names of the last 2 sheets but I can always just delete them manually. B3 = sheet1 name B4 = sheet2 name B5 = sheet 3 name and so on Thx. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can collect data from multiple sheets in the same workbook? | Excel Discussion (Misc queries) | |||
| use a worksheet as a form to collect data | Excel Worksheet Functions | |||
| Macro to capture worksheet names | Excel Worksheet Functions | |||
| collect data from different worksheet | Excel Worksheet Functions | |||
| How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Threaded Mode
