Copying a worksheet-part of a larger piece of code

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")


--
Regards Ron de Bruin
http://www.rondebruin.nl


"SusieQ" <SusieQ.22yvd0_1139496304.2487@excelforum-nospam.com> wrote in message
news:SusieQ.22yvd0_1139496304.2487@excelforum-nospam.com...
>
> 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
>
>
> --
> SusieQ
> ------------------------------------------------------------------------
> SusieQ's Profile: http://www.excelforum.com/member.php...o&userid=30818
> View this thread: http://www.excelforum.com/showthread...hreadid=510569
>