Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve the sheet name?
Does anyone have any suggestions on how to retrieve the sheet name?
For example, the sheet is named 'Date", I would like to retrieve its name into cell A1, does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve the sheet name?
On 8 avr, 23:30, Eric wrote:
Does anyone have any suggestions on how to retrieve the sheet name? For example, the sheet is named 'Date", I would like to retrieve its name into cell A1, does anyone have any suggestions? Thanks in advance for any suggestions Eric Hello, You can write a macro that automaticly writes the active sheet name in the A1 cell. In VBA it can be coded like this : Sub getSheetNameInA1() ActiveSheet.Range("A1") .value=ActiveSheet.Name End Sub Caution: it will overload the previous data in cell "A1" You can launch this macro via the "Tools / Macros menu" Hope this helps |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve the sheet name?
Hi Eric,
The the following... =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) "Eric" wrote: Does anyone have any suggestions on how to retrieve the sheet name? For example, the sheet is named 'Date", I would like to retrieve its name into cell A1, does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup value one and retrieve more then one corresponding value fromanother sheet | Excel Worksheet Functions | |||
Retrieve ID from NT? | Excel Discussion (Misc queries) | |||
How do i retrieve Windows User name on a excel sheet? | Excel Discussion (Misc queries) | |||
to retrieve a particular value from excel sheet | New Users to Excel | |||
Retrieve Data from one sheet to another | Excel Worksheet Functions |