Hi There,
I am trying to create a Macro that will allow me to change the Print Area based on the value in a specific cell. The cell in question is A10, this cell has a dropdown and I would like the print area to change based on the selection. For example if I select "8" from the dropdown I would like the print area to be D4:DK33 but if it is "14" I would like the print area to be D4:GQ33.
Thank you in advance for any assistance!
Bookmarks