Hi

I think I am getting at what you are after!

Try this :-

Presuming that the variable containing the desired sheet number i
'Count' and the value of 'Count' now is say 3 - hence your macro shoul
select the 3rd worksheet in your workbook an name it as 'Week3', the
this would perhaps help :-

Worksheets(Count).select
activesheet.name = "Week" & Count


This will select the 3rd worksheet in the workbook starting from th
first worksheet beginning from left.

See if this helps - otherwise let me know and I will see if I can offe
further assitance.


Best regards


Deepak Agarwa

--
agarwaldv
-----------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...fo&userid=1134
View this thread: http://www.excelforum.com/showthread.php?threadid=27008