| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Can you tell me how to reference a sheet tab name within Excel. I can't
remember what to do. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
!
sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
thanks but I think my question wasn't clear enough.
I need to enter a formula that returns the name of the worksheet e.g. if the worksheet was named June I need the formula to return the result June - hope this makes for sense. "Don Guillett" wrote: ! sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Try this -
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) (cell("filename") returns full information including path to the current worksheet). The worksheet name is the last piece of information in the string and just before the worksheet name appears a closed square bracket (]). Once you find that in the string, you just need all remaining characters in the string after the ] Ger Nicola wrote: thanks but I think my question wasn't clear enough. I need to enter a formula that returns the name of the worksheet e.g. if the worksheet was named June I need the formula to return the result June - hope this makes for sense. "Don Guillett" wrote: ! sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
thanks but it returned #value error!
"Gearoid" wrote: Try this - =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) (cell("filename") returns full information including path to the current worksheet). The worksheet name is the last piece of information in the string and just before the worksheet name appears a closed square bracket (]). Once you find that in the string, you just need all remaining characters in the string after the ] Ger Nicola wrote: thanks but I think my question wasn't clear enough. I need to enter a formula that returns the name of the worksheet e.g. if the worksheet was named June I need the formula to return the result June - hope this makes for sense. "Don Guillett" wrote: ! sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
Hi Nicola
The workbook needs to have been saved before this can work. -- Regards Roger Govier "Nicola" wrote in message ... thanks but it returned #value error! "Gearoid" wrote: Try this - =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) (cell("filename") returns full information including path to the current worksheet). The worksheet name is the last piece of information in the string and just before the worksheet name appears a closed square bracket (]). Once you find that in the string, you just need all remaining characters in the string after the ] Ger Nicola wrote: thanks but I think my question wasn't clear enough. I need to enter a formula that returns the name of the worksheet e.g. if the worksheet was named June I need the formula to return the result June - hope this makes for sense. "Don Guillett" wrote: ! sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula
I was looking for this answer also (great minds think alike), but how would
you adjust this to get the tab name of ANOTHER tab in ANOTHER file..? Thanks, -Mark "Roger Govier" wrote: Hi Nicola The workbook needs to have been saved before this can work. -- Regards Roger Govier "Nicola" wrote in message ... thanks but it returned #value error! "Gearoid" wrote: Try this - =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) (cell("filename") returns full information including path to the current worksheet). The worksheet name is the last piece of information in the string and just before the worksheet name appears a closed square bracket (]). Once you find that in the string, you just need all remaining characters in the string after the ] Ger Nicola wrote: thanks but I think my question wasn't clear enough. I need to enter a formula that returns the name of the worksheet e.g. if the worksheet was named June I need the formula to return the result June - hope this makes for sense. "Don Guillett" wrote: ! sheet3!a1 -- Don Guillett SalesAid Software "Nicola" wrote in message ... Can you tell me how to reference a sheet tab name within Excel. I can't remember what to do. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
