Cell = worksheet tab

[Mark]

Can some tell me how to get a cell to automatically equal
what the worksheet tab is named.

 

[Jason Morin]

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Note: file must be already be saved for this to work.

HTH
Jason
Atlanta, GA

 

[Jim]

Jason, hopefully you will read this. I was also looking
for this answer. Thanks for your help. Would you mind
explaining how and why this works.

Thanks Jim

-----Original Message-----
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

Note: file must be already be saved for this to work.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can some tell me how to get a cell to automatically equal
what the worksheet tab is named.
.

.

 

[GB]

"J.E. McGimpsey"

[and to the older
coders, is a familiar large binary integer (i.e., 2^8 - 1, or
11111111)].

There are 10 types of person - those who understand binary and those who
don't.