name of the activesheet
there are 3 worksheets, named:
worksheet_A worksheet_B worksheet_C in cell B2 for each sheet, how can i display the name of the corresponding sheet? if the name of the sheet changes so should the contents of B2. so cell B2 on worksheet_A, will show: "worksheet_A" thank you. |
name of the activesheet
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,100)
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "rasta" wrote in message ... there are 3 worksheets, named: worksheet_A worksheet_B worksheet_C in cell B2 for each sheet, how can i display the name of the corresponding sheet? if the name of the sheet changes so should the contents of B2. so cell B2 on worksheet_A, will show: "worksheet_A" thank you. |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com