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

  • Thread starter Thread starter Neil
  • Start date Start date
N

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
 
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
 
Back
Top