Either use its index
Sheets(1).Copy After:=Sheets(1)
or its codename
Sheet1.Copy After:=Sheets(1)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"zerosleep" wrote
in message ...
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