Hi Andy,
There may be a much easier way todo this, but you can paste the below into a
module:
Public Function tab_name()
tab_name = ActiveSheet.Name
End Function
then in A1 enter = tab_name()
This will return the tab name into call A1 but if you make a change to the
tabs name, you will have to re-enter the formula as it won't autocalc.
Thanks,
Simon
Andy the Yeti wrote:
Hi,
Is it possible to have Excel populate a cell (for example A1) with the name
of that worksheet tab? This could then be used across the rest of the book.
Many thanks
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1