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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing previous worksheets in formula 3
Subject: Macro- Copy same rows into own worksheets 2
Multiple sheets using single chart 3
Problems with Paste 4
Excel Copy Method Failing. 2
Get the name of a newly copied worksheet 4
Copy and paste a chart to another worksheet 4
Add new worksheet and assign it to an object variable? 2

Top