Dynamic Print Area

[krisso]

I am trying to set up a dynamic print area where the print area will always print A1:A20 and select 7 columns to the right to print from A1. The issue is that I am hiding columns once the day is done and everything I have looked at using offset etc is stating that I have to name cell references. Does anyone have any suggestions I can try?

Thanks