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

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

beautiful!!!

thank you bob, I guess it was so simple I didn't even think of it.
all this time I would just change the sheet name to reflect the
macros...much easier now.

-zerosleep


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