Dynamic print range using macro and constant print area.

[makhanaka]

I want to setup an excel sheet for shop floor where A1:AK6 is freeze pane. This should appear on all pages.
Now I want a dynamic print range along with that. Here the person specifies the range to be printed. Can someone please help me?

Thanks