Zoom settings for printing using VBA

    Hi


    I have a macro that automaticaly prints out data from my workbook.


    Does anyone know the code for setting the zoom function so that the data/worksheet to be printed fits the page exactly?


    Also, can the paper size be automatically configured?


    Thanks
    Johno

    Re: Zoom settings for printing using VBA


    Hi Johno


    Did you try this?
    Worksheets("Sheet1").PageSetup.PaperSize = xlPaperLegal
    Worksheets("Sheet1").PageSetup.FitToPagesWide = 1


    Thanks
    Denis

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login