Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get worksheets' names in spreadsheet
As you know, a excel spreadsheet workbook can contains some worksheets and
each worksheet has its names, my problem is how to get these names. Who can Help me ? Any help will be very very appreciated! -- marxi |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get worksheets' names in spreadsheet
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
The above pasted into any cell on a worksheet will return the name of that sheet. If you want the names of all sheets on one sheet then this can be pasted into the indivdual sheets and referenced on the summary sheet "marxi" wrote: As you know, a excel spreadsheet workbook can contains some worksheets and each worksheet has its names, my problem is how to get these names. Who can Help me ? Any help will be very very appreciated! -- marxi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get worksheets' names in spreadsheet
first and foremost, thank you for your advise!
The spreadsheet I said is a kind of COM for Csharp.NET. It can drog on the winform to work for users as excel. my problem is how to get the name of each worksheet using C# language. I do not know the type of "ws" which mentioned in your answer! Thanks again. -- marxi "Mike" wrote: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) The above pasted into any cell on a worksheet will return the name of that sheet. If you want the names of all sheets on one sheet then this can be pasted into the indivdual sheets and referenced on the summary sheet "marxi" wrote: As you know, a excel spreadsheet workbook can contains some worksheets and each worksheet has its names, my problem is how to get these names. Who can Help me ? Any help will be very very appreciated! -- marxi |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get worksheets' names in spreadsheet
Hi
Public Function TabI(TabIndex As Integer, Optional MyTime As Date) As String TabI = Sheets(TabIndex).Name End Function In a column, you use this UDF to return 1st, 2nd, etc sheet name - like this A1=IF(ISERROR(TABI(ROW(),NOW())),"",TABI(ROW())) (and copy down) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "marxi" wrote in message ... As you know, a excel spreadsheet workbook can contains some worksheets and each worksheet has its names, my problem is how to get these names. Who can Help me ? Any help will be very very appreciated! -- marxi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy column and header names from existing spreadsheet to new spre | New Users to Excel | |||
Can I print the tab names in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Excel should apply names in all worksheets of a workbook | Excel Discussion (Misc queries) | |||
deleting worksheets from names in a range | Excel Discussion (Misc queries) | |||
adding values across worksheets in a spreadsheet | Excel Worksheet Functions |