| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
printing the list of wroksheets in a workbook
How can I list and print a list of worksheets in a workbook?
|
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
printing the list of wroksheets in a workbook
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? |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
printing the list of wroksheets in a workbook
thanks
works like a charm "Arvi Laanemets" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP: Use the autofilter result on one workbook to filter the next list on another workbook | Excel Worksheet Functions | |||
| Printing a list of all links in a workbook | Excel Discussion (Misc queries) | |||
| Printing Workbook | Excel Discussion (Misc queries) | |||
| problem copying excel wroksheets | Excel Discussion (Misc queries) | |||
| printing the list of wroksheets in a workbook | Excel Worksheet Functions | |||
Linear Mode
