Print Macro - Hide/Unhide Columns based on Value

Hello,
I have a print issue that changes on a monthly basis. See attachment for a better understanding.

The range I am trying to print is B2:BS50.

I have identified the columns that I would like to have printed by putting a “P” in Row1 (A1:BS1). The columns I don’t want printed (hidden) are marked with a “H” in the same range (A1:BS1).

I am looking for a print macro that will hide all columns within the range that are marked with an “H”, print the range on 11x17 landscape, and then unhide the columns that were previously hidden.

Any feedback helps. Thank you.

This macro might work for you...

Please Login or Register  to view this content.

If you record a macro of yourself printing the worksheet, you'll see a lot of other 'PageSetup' options you can modify, too.

This works! Thank you!

This is very informative. Thank you for the lesson!