Home |
Search |
Today's Posts |
#1
|
|||
|
|||
printing the list of wroksheets in a workbook
How can I list and print a list of worksheets in a workbook?
|
#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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
Try this macro:
sub sheets_list() r=activecell.row s=activecell.column for a = 0 to sheets.count-1 cells(r+a,s).value = sheets(a+1).name next a end sub |
Reply |
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 |