Posts by royUK

    Done some more experimenting and this works

    I've edited the code slightly

    Try this. I've left all the options that you can change in the PageSetup for reference. I haven't checked it so let me know if it needs any amendments

    If you want to adjust multiple sheets within each workbook use

    1. Sheets.Select
    2. Selection.ColumnWidth = 10

    Try this. The code assumes each workbook has one sheet.

    This will add a unique identifier based on the time it is saved. Note that you must reset DisplayAlerts as well

    It would help to see your file