Two different print previews on two differnt operating systems.

E

Eric

Hello all. Hoping someone can help me here.

Has anyone ever ran across a situation where when the user
clicks print preview in Excel, on one operating system
(Windows NT) you get 2 pages, but when on another
operating system (Windows 2000 or XP) it comes in as one
page? The same situation occurs when the user prints.

If so, how did you solve this problem?
 
R

Ron de Bruin

Hi Eric

Always a problem with different printers
If you print with code you can try this

Sub test()
With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
ActiveSheet.PrintOut
End Sub
 
Top