It's usually best not to rely on Microsoft's web interface to the newsgroup.

Better to use a news server to access the newsgroup directly:
http://www.cpearson.com/excel/HintsA...roupUsers.aspx
--
David Biddulph

"Finance Guru" wrote in message
...
Thanks ... but don't blame me. 3 times I posted and it said error when
submitting
--
Wales - the land of fire breathing dragons and rugby palaying wizards.


"David Biddulph" wrote:

Please don't ask the same question in 3 different threads.
--
David Biddulph

"Finance Guru" wrote in message
...
Hi All,

Using Excel 2007

Can I name a worksheet tab from a cell contained within the worksheet.
I
want to name a worksheet from the date contained in say A1 = 30/06/2009
(dd/mm/yyyy)
so the tab would be called 'June' from the month number in A1.

If so could someone give me either the function or the code to do this.
If
it is code could also detail how to apply it, as I am not that
familiar
with
code.

Many thanks for taking the time out to respond.

FinanceGuru


--
Wales - the land of fire breathing dragons and rugby playing wizards.








--
Wales - the land of fire breathing dragons and rugby playing wizards.