Thread: Copy WorkSHeet To New Book With Print Page Settings ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Iacovou Mike Iacovou is offline
external usenet poster
  
Posts: 32
Default Copy WorkSHeet To New Book With Print Page Settings ?
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
Reply With QuoteReply With Quote