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

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

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

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"
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