Thread: WORKSHEET
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.