Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suppressing a footer only on the first page of a printout | Excel Discussion (Misc queries) | |||
suppressing a footer only on the first page of a printout | Excel Programming | |||
suppressing a footer on the first page of a printout | Excel Discussion (Misc queries) | |||
suppressing a footer on the first page of a printout | Excel Programming | |||
ActiveSheet.Printout or Page Setup? | Excel Programming |