Worksheet Name

  • Thread starter Thread starter ZootRot
  • Start date Start date
Z

ZootRot

MS Excel 2002 SP2

Is there a spreadsheet or VBA function which shows me the name of the
worksheet? I want to use the name of the sheet (in my case year-month) in a
formula.

Thanks.
 
Hi
to get the sheet name on your worksheet use the following formula on
your sheet:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))
 
Thanks.
Truly ingenious!


Frank Kabel said:
Hi
to get the sheet name on your worksheet use the following formula on
your sheet:
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("file
name",A1),1))

--
Regards
Frank Kabel
Frankfurt, Germany

ZootRot said:
MS Excel 2002 SP2

Is there a spreadsheet or VBA function which shows me the name of the
worksheet? I want to use the name of the sheet (in my case year-month) in a
formula.

Thanks.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA 0
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Assigning a worksheet name to a variable 3
Named Range Formula 3
Reference sheets named by DAY 7
Embed information in Worksheet for error checking 0
[Q] How to create new worksheets based on an array (via named range) 4

Back
Top