View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Finance Guru Finance Guru is offline
external usenet poster
 
Posts: 83
Default Naming worksheets tabs from another cell reference

Hello All,

Using Excel 2007.
Question - Can you name a worksheet tab from a Cell within the worksheet. In
a1 I have the date 30/06/09 (dd/mm/yyyy) and I would like the worsheet to be
called "June" picked up from the mm in the date.

If so could someone give me the function / code ( and how to apply the code
as well ) as I am a fairly inexpert user of excel.

Many thanks for taking the time out to reply

FinanceGuru

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