Tab Name
Apologies for my mistake I meant to post this to the
Excel.WorksheetFunctions newsgroup....... Is there a way of displaying the tab name in a cell? PWS "Nigel" wrote in message ... Maybe..... Range("A1") = ActiveSheet.Name -- Regards, Nigel "Paul W Smith" wrote in message ... Is there a way of displaying the tab name in a cell? PWS |
Tab Name
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Paul W Smith" wrote in message ... Apologies for my mistake I meant to post this to the Excel.WorksheetFunctions newsgroup....... Is there a way of displaying the tab name in a cell? PWS "Nigel" wrote in message ... Maybe..... Range("A1") = ActiveSheet.Name -- Regards, Nigel "Paul W Smith" wrote in message ... Is there a way of displaying the tab name in a cell? PWS |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com