VBA speed up

Hello bensonsearch,

While some improvements could be made to the code to speed it up, the biggest stumbling block to speeding the code up is the PageSetup. Unfortunately, this runs very slowly.

If you don't have to set the page print properties each time the macro runs, that will greatly improve the speed. If the same settings for the worksheet will be used again and again, set them once and then save the workbook.