Excel Change Print Area with VBA

Setting the print area on a moving range can be a difficult and frustrating thing to trap. You may wish to trap a specific range with your print area or have the print range only consider certain columns. Let's say you have a couple of helper columns in an Excel workbook and don't want these columns to be printed but you want the columns to be visible. You could manually set the print area to exclude the print area but now you have more data which you have added and you would like the print area to update in kind.

Tags Excel, Print, area, vba, set