Worksheet tab names

R

Ron Wilson

Is there a way to reference a cell inside a worksheet to tell me th
name of the worksheet? I have say 6 different worksheets in a file
named Sales,Costs,etc and when I print the worksheets I want cell A1 t
disply the worksheet name
 
P

Paul B

Ron, here is one way, file must have been saved

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
R

Roger Govier

Hi Ron

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)
Note the file needs to have been saved before this will work.

Regards

Roger Govier
 
J

jenbrunson

What I do in this case is add the tab name to the header of th
spreadsheet.

View - header and footer - Custom header - click on the last icon - ok
 
Top