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.

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.

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.

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.

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.