Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying page setup information
Is there anyway to copy/paste the page setup information
from one worksheet to another? I am creating a new worksheet via VBA code and would like to copy the print information over. I can not just copy the whole worksheet to another workbook as there are linked formulas that can not be copied. I am also copying multiple worksheets at the same time (via an array) and each worksheet has different page setups (page margins, etc.) Any help would be greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying page setup information
See one answer to your multi-posting of this question in
Worksheet.Functions. That answer is a manual method. For code, you need to do each sheet individually by making the appropriate settings. You can't copy. -- Regards, Tom Ogilvy tbjohnson2 wrote in message ... Is there anyway to copy/paste the page setup information from one worksheet to another? I am creating a new worksheet via VBA code and would like to copy the print information over. I can not just copy the whole worksheet to another workbook as there are linked formulas that can not be copied. I am also copying multiple worksheets at the same time (via an array) and each worksheet has different page setups (page margins, etc.) Any help would be greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
copy footer without copying page setup | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) |