#1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 74
Default 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




  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"