Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Empty Pages When I Print From Excel

Status
Not open for further replies.
jbl1167

jbl1167

Programmer
Oct 2, 2006
78
US
We do print thousands of Excel Documents. One of the problems that we have is that when we print there could be hundreeds of empty pages. How could I eliminate empty pages from Excel programatically?

Thank you
 
Sort by date Sort by votes
Print filled range only:
Range("ReferenceToPrintedRange").Printout)

To customise printing, you can adjust printed range pages per height/width:
WithWorksheets("PrintedWorksheet").PageSetup
.FitToPagesWide = 999
.FitToPagesTall = 1
' or
.FitToPagesWide = 1
.FitToPagesTall = 999
End Width

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
4K
dhookom
dhookom
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
897
strongm
strongm
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
892
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top