Worksheet Name

B

Bob

What is the formula to display just the worksheet name in cell? For instance
the worksheet name is January 2007 and I would like January 2007 displayed in
several areas within this worksheet. I am using Excel 2003.
 
P

PCLIVE

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

Your file must be saved for this to work.

HTH,
Paul
 
B

Bob

Perfect....Thanks for the quick reply!!!

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

Your file must be saved for this to work.

HTH,
Paul

Bob said:
What is the formula to display just the worksheet name in cell? For
instance
the worksheet name is January 2007 and I would like January 2007 displayed
in
several areas within this worksheet. I am using Excel 2003.
Click to expand...
Click to expand...
 
Top