ExcelBanter - Using the wotksheet name in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using the wotksheet name in a cell (https://www.excelbanter.com/excel-worksheet-functions/79147-using-wotksheet-name-cell.html)

henry

Using the wotksheet name in a cell

Hi

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

something like =me.name

regards
Henry

Gary''s Student

Using the wotksheet name in a cell

Try:

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

Once the file has been saved
--
Gary''s Student

"henry" wrote:

Hi

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

something like =me.name

regards
Henry

henry

Using the wotksheet name in a cell

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

Once the file has been saved
--
Gary''s Student

Thanks

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

cheers
Henry

Gary''s Student

Using the wotksheet name in a cell

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" wrote:

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

Once the file has been saved
--
Gary''s Student

Thanks

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

cheers
Henry

All times are GMT +1. The time now is 10:16 PM.