| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WORKSHEET
Is there a way to reference the worksheet tab name in a cell? I want to see
the worksheet tab name diplay in for example A1. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WORKSHEET
One option: http://support.microsoft.com/kb/213475
Dave -- Brevity is the soul of wit. "mmmbl" wrote: Is there a way to reference the worksheet tab name in a cell? I want to see the worksheet tab name diplay in for example A1. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WORKSHEET
Try this:
=MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1,125) Use this *exactly, don't change *anything*! Just make sure that the WB is *saved*, or you'll get a #Value! error. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mmmbl" wrote in message ... Is there a way to reference the worksheet tab name in a cell? I want to see the worksheet tab name diplay in for example A1. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WORKSHEET
THank you!
"RagDyer" wrote: Try this: =MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1,125) Use this *exactly, don't change *anything*! Just make sure that the WB is *saved*, or you'll get a #Value! error. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mmmbl" wrote in message ... Is there a way to reference the worksheet tab name in a cell? I want to see the worksheet tab name diplay in for example A1. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
WORKSHEET
Thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mmmbl" wrote in message ... THank you! "RagDyer" wrote: Try this: =MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1,125) Use this *exactly, don't change *anything*! Just make sure that the WB is *saved*, or you'll get a #Value! error. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "mmmbl" wrote in message ... Is there a way to reference the worksheet tab name in a cell? I want to see the worksheet tab name diplay in for example A1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace a worksheet with lists | Excel Worksheet Functions | |||
| I need to copy a text value from one worksheet to another | Excel Discussion (Misc queries) | |||
| Best Approach to Worksheet Synchronization | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Hybrid Mode
