Copying a worksheet

  • Thread starter Thread starter SusieQ
  • Start date Start date
S

SusieQ

Hi,

I need to copy a worksheet and paste it in between another two in the
same workbook. I need to copy the whole worksheet so that all the page
setup and print area settings are the same.

This step will be part of a larger piece of code so I need to use VBA.

Any help appreciated.
Thanks
SusieQ
 
hi Susie

You can use this to copy the activesheet after a sheet named "Sheet2"

ActiveSheet.Copy after:=Sheets("Sheet2")
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy Worksheet 3
Copy and paste to other worksheets 2
VBA - Copying a Certain Colored Row to Paste in Another Worksheet 1
Code to copy worksheet 5
Copying Worksheets 1
MS Excel VBA Worksheets group tables in one table. 1
Copy a worksheet 1

Back
Top