Using the wotksheet name in a cell

H

henry

Hi

I would like to display the worksheet name is a cell, is that possible
(how)?

something like =me.name

regards
Henry
 
G

Gary''s Student

Try:

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

Once the file has been saved
 
H

henry

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

Once the file has been saved
Click to expand...
Thanks

I'm looking for the sheetname not the workbookname, the sheetname could be
"Sheet1" or "February 2006".


cheers
Henry
 
G

Gary''s Student

Hi Henry:

Give it a try. On my system (WIN XP EXCEL XP) it returns the worksheet name
(tab name)

Good Luck
-- Gary's Student


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

Once the file has been saved
Click to expand...
Thanks

I'm looking for the sheetname not the workbookname, the sheetname could be
"Sheet1" or "February 2006".


cheers
Henry
Click to expand...
 
S

Scoops

Hi Henry

Copy this function into a module in your workbook:

Function ShtName()
ShtName = ActiveSheet.Name
End Function

To use it, type =ShtName() into a cell

Regards

Steve
 
Top