| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Response to "Can I get a list of names of all the tabs..."
Couldn't reply, so posting as new!
Write a Function, in VBA like: Function tabName(idx As Integer) As String tabName = Sheets(idx).Name End Function (Alt/F11; then Insert/Module. then put in the above). In the worksheet, enter =TABNAME(ROW(A1)) and fill down for as many sheets as there are. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating list of names from specific value | Excel Discussion (Misc queries) | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| auto updating list | Excel Worksheet Functions | |||
| How to make a chart from a list of names? | Charts and Charting in Excel | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Linear Mode
