Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hondo Chalthoum    on Oct 03 In MS Office Category.

  
Question Answered By: Adalwine Fischer   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.

Share: 

 
 
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: