Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????

  • Thread starter Thread starter wjoc1
  • Start date Start date
W

wjoc1

Thanks Tom,

I figured this was probably the reason. But if I can go into page brea
preview and manually adjust these additional page breaks I can forc
Excel to print out the area I want. Why can't I do this in code, i
there any way?

Lia
 
When you drag a pagebreak right or down in pagebreak preview mode, if you
then go to pagesetup, you will see the zoom option has been selected and the
zoom has been set at something less than 100%. This has changed the number
of rows and columns allowed on a page. You can do this with code as well.
(Zoom is one of the parameters you can set for the pagesetup object. )
 

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

Similar Threads

Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code???? 1
HPageBreak not working - More info 1
hpagebreak and vpagebreak 6
HPageBreak not working 4
Puzzling printarea code 2
need help with hpagebreak 3
Range use on page 1
Selecting a Page (not a sheet) using VBA. 2

Back
Top