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