ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I use a formula to get the worksheet name into a cell? (https://www.excelbanter.com/excel-worksheet-functions/6724-can-i-use-formula-get-worksheet-name-into-cell.html)

KellyB

Can I use a formula to get the worksheet name into a cell?
 
Is there a formula that will output the current sheet name in text format
(into a cell)?

I want the same type of &[Tab] functionality used in the custom
headers/footers, but in a cell in the worksheet.

Frank Kabel

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Regards
Frank Kabel
Frankfurt, Germany

"KellyB" schrieb im Newsbeitrag
...
Is there a formula that will output the current sheet name in text

format
(into a cell)?

I want the same type of &[Tab] functionality used in the custom
headers/footers, but in a cell in the worksheet.




All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com