View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Can "print area" cover entire page???

I tried pasting the following Visual Basic code into some of my
Excel modules:

With Worksheets("Sheet1").PageSetup
.Zoom = False
.FitToPagesTall = 1
.FitToPagesWide = 1
End With


I then tried printing my sheet, but I saw no difference at all. I just to
eliminate all margins to zero, and force excel to print my print area
on one ENTIRE page.

Got any more tips??


"Rick Rothstein" wrote in message
...
Look up the FitToPagesWide and FitToPagesTall properties in the help
files... they are properties of the PageSetup object.

--
Rick (MVP - Excel)