Rogue vertical pagebreak

G

GSS

I'm using .Copy to pull several sheets from other
workbooks into one. One of the sheets adds a vertical
pagebreak within the print area range, in the copy.
The pagebreak does not exist in the source copy.
Looks like:
--------------------------
| |
| |
| |
| |
| |

Any experience with this?
 
T

Tom Ogilvy

Perhaps the page setup is different? (portrait vice landscape as an
example) or maybe the columnwidth is different. Or perhaps the source
workbook was last view with pagebreaks while attached to a different
printer - or maybe it isn't showing pagebreaks at all.
 
G

GSS

A co-worker suggested I set "Fit To 1,blank in pagesetup.
This removed the pagebreak in the copy. I did the same in
the sourve file and that stopped the pagebreak from being
created in the copy. Acceptable workaround for now.

Thanks for your suggestions!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top