Copy WorkSHeet To New Book With Print Page Settings ?

M

Mike Iacovou

Hi

Apologies again.
I am using VBA to copy selected worksheets to a newly created workbook.
cwkb is current workbook, nwkb is new book

cwkb.Worksheets(1).Copy After:=nwkb.Sheets(nwkb.Sheets.Count)

This works great for copying content, but one of the pages has been modified by the VBA to include page break codes, and printer settings (ie landscape, zoom 70% etc). Is it possible to copy this across aswell ??
Many thanks

Mike
 
V

Vasant Nanavati

When I copy a worksheet into another workbook, the Page Setup parameters,
page breaks, etc. are carried over. Does this not happen for you?

--

Vasant


Mike Iacovou said:
Hi

Apologies again.
I am using VBA to copy selected worksheets to a newly created workbook.
cwkb is current workbook, nwkb is new book

cwkb.Worksheets(1).Copy After:=nwkb.Sheets(nwkb.Sheets.Count)

This works great for copying content, but one of the pages has been
Click to expand...
modified by the VBA to include page break codes, and printer settings (ie
landscape, zoom 70% etc). Is it possible to copy this across aswell ??
 
M

Mike Iacovou

When i use the copy function listed previously, it doesn't copy these changes. The print settings are set in VBA in the originating workbook. If there is a copy command in VBA that will preserve these settings, that would be kinda helpful.
TIA
 
Top