I want to make a copy of the 1st sheet and then rename it.
the name of the sheet is always changing, anyway I can get
VB to select the sheet no matter what it's name is?

Sheets("sheet-x").Copy After:=Sheets(1)
Sheets("sheet-x (2)").Select
Sheets("sheet-x (2)").name = "sheet-y"


--
zerosleep
------------------------------------------------------------------------
zerosleep's Profile: http://www.excelforum.com/member.php...o&userid=17846
View this thread: http://www.excelforum.com/showthread...hreadid=518695