| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| i formatted an excel sheet, to fit my page, how do i add a page? | New Users to Excel | |||
| Conditional page break if merged rows won't fit on the page. | Excel Worksheet Functions | |||
| sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
| How to I set up a sheet to print colums/rows on every page in exce | Excel Discussion (Misc queries) | |||
![Jim Cone[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
