Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the function to return a sheetname in a cell in Excel?
I was hoping it was this, and it ain't.
=sheetname() or =sheet() |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the function to return a sheetname in a cell in Excel?
The workbook has to be saved first.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) you can put that anywhere, even in A1 -- Regards, Peo Sjoblom "judi" wrote in message ... I was hoping it was this, and it ain't. =sheetname() or =sheet() |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the function to return a sheetname in a cell in Excel?
Thank you. I realize now that I am not the first to ask this question. I
appreciate your speedy answer. I will share with my colleagues. Cheers! "Peo Sjoblom" wrote: The workbook has to be saved first. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) you can put that anywhere, even in A1 -- Regards, Peo Sjoblom "judi" wrote in message ... I was hoping it was this, and it ain't. =sheetname() or =sheet() |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what's the function to return a sheetname in a cell in Excel?
It could be if you had a UDF
Function SheetName(Optional ByVal rng As Range) As String Application.Volatile If rng Is Nothing Then Set rng = Application.Caller SheetName = rng.Parent.Name End Function =SheetName() The workbook does not have be saved first. But the native function Peo posted works a little faster and who would want to know the sheetname in an unsaved file? Gord Dibben MS Excel MVP On Thu, 2 Oct 2008 15:14:03 -0700, judi wrote: I was hoping it was this, and it ain't. =sheetname() or =sheet() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically update SheetName in workbook sub if SheetName changes | Excel Discussion (Misc queries) | |||
Using a cell to reference sheetname in vlookup function | Excel Worksheet Functions | |||
Excel worksheet function that will return the currency for a cell | Excel Worksheet Functions | |||
Need Excel Function that will return # of char in preceding cell | Excel Discussion (Misc queries) | |||
Need Excel Function that will return # of char in preceding cell | Excel Worksheet Functions |