LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for naming tabs SharonJo Excel Discussion (Misc queries) 10 April 5th 08 01:08 AM
naming tabs steve Excel Worksheet Functions 2 December 1st 07 08:15 PM
Naming tabs Mike Excel Worksheet Functions 5 November 27th 07 05:04 PM
Naming Tabs ebro Excel Discussion (Misc queries) 3 July 13th 06 11:07 PM
naming tabs Jeff Excel Worksheet Functions 8 February 6th 06 04:41 AM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"