Renaming worksheets to include the years

[Awest1969]

Hi Everyone,

I need some script that will rename my worksheets to include the year (i.e 2009 & 2008 & 2007). I have the date appearing in cells B43:B46 that change annually. So Ideally I would what sheet one to be named as YE and the data that is in cell B43 and sheet 2 to be name YE and the value in cell 44 or just use the date.

Many Thanks for all your help!

 

[ravishankar]

Hi
Try these codes for a start

Dim a as long
For a = 1 to sheets.count
worksheets(a).name = "YE" & worksheets(a).cells(44,2)
Next a

Ravi

 

[Awest1969]

Many Thanks

Worked a treat

Sorry for the delay got tied up with other stuff