I am trying to write a macro that automatically sets a print area to show only the column with the current date. (My table has columns for every day of the year, and I would like the user to be able to click a button so that all columns are hidden except the current date.)

Would also be interested if the dates were listed in rows instead of columns.