Pasting to a new page on existing sheet if not enough rows on the page

[Neil]

Hi,

Sorry if the subject doesn't make sense.

What i am trying to do is paste a range of data onto a sheet, but the
catch being that if there is not enough rows on that page (i.e. it
crosses over 2 pages) then i need the data to automatically paste to
start of the next page.

Any help would be greatly appreciated.

Thanks

 

[Jim Cone]

Trying to do that can be frustrating and you will never be sure that its will work every time.
The idea being that if a page break intersects the pasted data, move the data.
Well moving the data, can/will change the page break location.
There are other complicating factors including row height and printer settings.
Try entering a manual page break just ahead of each paste and see if you can live with it.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/SpecialPrint

..
..
..

"Neil" <[email protected]>
wrote in message
Hi,
Sorry if the subject doesn't make sense.

What i am trying to do is paste a range of data onto a sheet, but the
catch being that if there is not enough rows on that page (i.e. it
crosses over 2 pages) then i need the data to automatically paste to
start of the next page.
Any help would be greatly appreciated.
Thanks