Tab name into a cell...
 

Hi guys,

Is there a formulae (or other solution) of displaying the Sheet name (ie
the TAB) into a cell (say a1) in the sheet...?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

Tab name into a cell...
 

one way

Range("a1").Value = ActiveSheet.Name

--


Gary


"Darin Kramer" wrote in message
...


Hi guys,

Is there a formulae (or other solution) of displaying the Sheet name (ie
the TAB) into a cell (say a1) in the sheet...?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

Tab name into a cell...
 

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Darin Kramer" wrote in message
...


Hi guys,

Is there a formulae (or other solution) of displaying the Sheet name (ie
the TAB) into a cell (say a1) in the sheet...?

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***