Specific print settings in macro

I am trying to print data on one sheet of paper. It will print on 9 sheets unless I change the print setting to print 9 pages on one sheet. Can I specify the sheets printed per page in the macro? What is the identifier I would use.

Please Login or Register  to view this content.

Thanks

Hello Rodeoclown,

The macro recorder doesn't always set all of the properties for you. In this case, the two properties you need to set are .FitToPagesTall and .FitToPagesWide. If you set the .Zoom property, it will override these two property settings. In VBA code it is rare to have to select and object before an action can be preformed. I have condensed the code by not selecting objects unnecessarily.

Please Login or Register  to view this content.