| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Hi
Copy the function below into VBA module Public Function TabByIndex(TabIndex As Integer) As String Application.Volatile TabByIndex = Sheets(TabIndex).Name End Function Into A1 enter the formula =IF(ISERROR(TABBYINDEX(ROW())),"",TABBYINDEX(ROW() )) and copy down. -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "D@annyBoy" wrote in message ... How can I list and print a list of worksheets in a workbook? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Threaded Mode
