worksheet copy method

M

Marek

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 :
 
T

Tom Ogilvy

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