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