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