Thanks for the reply Tom!

I think the best thing I can take out of that is probably the simplest
thing, escaping to a variable within the page name using & var & , I
haven't used this language so did not know how to include variables
(had tried all variations of methods I knew! :)

What I've done is used primitive excel macros and C&P the drop down
field into another cell, which copies it as just a general cell, I've
then copied the cell to the cell below, which has incremented it's
value from Week 1 to Week 2 , I then create a variable varWeek from
that new cell, and set the current page name to

CurrentPageName = "[Time By Week].[All Time By Week].[2005]. _
["& varWeek & "]"

Works a treat! Thankfully this works well too...

IF varWeek "Week 52"
THEN varWeek = "Week 1"
ENDIF

I've also replace the year with a variable, with I get with the
following

varYear = Trim(VBA.Format(Now(), "YYYY"))

Hoepfully this means, when the macro runs in the 1st week of 2006, it
will select 2006 as the year and reset Week to Week 1. Thanks for
helping me in simplifying this for me!!

Regards,
Keilan