people, in help i saw that worksheet object has copy method

but how to copy a worksheet with predefined name

for example now i'm copy worksheets by this

Worksheets("graph").Copy after:=Worksheets("...")
Worksheets("graph (2)").Name = "s"
CStr(rs.Fields("csheet"))


but i want to copy worksheet with predefined name,

it is possible,
i cant find that in help :

--
Message posted from http://www.ExcelForum.com

Worksheets("graph").Copy after:=Worksheets("...")
Activesheet.Name = "Mygraph"

--
Regards,
Tom Ogilvy


"Marek " wrote in message
...
people, in help i saw that worksheet object has copy method

but how to copy a worksheet with predefined name

for example now i'm copy worksheets by this

Worksheets("graph").Copy after:=Worksheets("...")
Worksheets("graph (2)").Name = "s" &
CStr(rs.Fields("csheet"))


but i want to copy worksheet with predefined name,

it is possible,
i cant find that in help :(


---
Message posted from http://www.ExcelForum.com/