View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
forunner101-3 forunner101-3 is offline
external usenet poster
 
Posts: 1
Default 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