Setting a Prinout format for Printout of a page.
Here is the problem? I am adding pages down a worksheet, which need to
be exactly the same size and same format. In my code I used a Range (a:B) select . Selection.copy Destintion of Range (A5). When I used the With Pagesetup.....End with to printpreview before printing. The print is a dynamic range which works. The problems is the Body of Print does not line up for each form as a separate page. It seems to run to gether and does not have a set format that it uses for each page. There can be as many as 15 format pages down. What do you suggest for code on the project. I would apprepiate your help and your knowledge to tackle this. -- Thank you for your help |
All times are GMT +1. The time now is 02:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com