Copying shts from one wbk to another

[jacqui]

What would be the equivalent in VBA code to the Right
click on the worksheet tab where you can then Copy the
sheet or sheets to another workbook (which in this case
would be a new one).

Can anyone help?

Many thanks
Jacqui

 

[Rob Bovey]

Hi Jacqui,

This macro will copy the first worksheet in the workbook where it runs
into a new workbook:

Sub CopySheet()
ThisWorkbook.Worksheets(1).Copy
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[J.E. McGimpsey]

One way:

ActiveWindow.SelectedSheets.Copy