I've got Tabs like week1 week 2 week3 week
Next week I'll have to rename week4 to week5 and week3 to week 4 and so on, then insert a new and name it week1
Any ideas
Thanks all
DJ

Why not give the tabs a name relating to the date?

E.g. for this week, ending on Friday 13 February 2004, you could name the
tab 20040213, or something similar such as 2004~02~13.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Duncan J" wrote in message
...
I've got Tabs like week1 week 2 week3 week4
Next week I'll have to rename week4 to week5 and week3 to week 4 and so
on, then insert a new and name it week1.
Any ideas?
Thanks all,
DJ

Duncan,

Try something like the following:

Dim N As Long
With ThisWorkbook.Worksheets
For N = .Count To 1 Step -1
.Item(N).Name = "Week" & Format(N + 1)
Next N
.Add(befo=.Item(1)).Name = "Week1"
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Duncan J" wrote in message
...
I've got Tabs like week1 week 2 week3 week4
Next week I'll have to rename week4 to week5 and week3 to week
4 and so on, then insert a new and name it week1.
Any ideas?
Thanks all,
DJ

Thanks for the ideas guys. The only reason I can't date it because the vlookups are in th macro. So I need it to be generic
Thanks again!