Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Set print range & page break preview all in one

  Asked By: Hondo    Date: Oct 03    Category: MS Office    Views: 1070
  

I do a lot of range selections that require setting page breaks to 1 so
the selection prints out on just one page. Usually the selection
spills over to 2 pages (or more).

It would be nice make a selection, lets say A1:Z50 then have a macro
set the selection area with no page breaks.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Adalwine Fischer     Answered On: Oct 03

I recorded a macro of my doing this and adapted it, missing out the
lines which were just the defaults and was left with:

Sub blah()
With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
Selection.PrintOut
End Sub

which seems to work fine. Record your own macro if you want to alter
other aspects which I've omitted here.

 
Didn't find what you were looking for? Find more on Set print range & page break preview all in one Or get search suggestion and latest updates.




Tagged:            

 
 
 
 

Related Post