Dynamic print range using macro and constant print area.

M

makhanaka

Joined
Apr 23, 2010
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic print area 3
how do I print a named dynamic range 7
Dynamic Print Area 2
Set Print Area 3
Macro to print specified range of several work sheets 2
Set Print Area Macro 1
Print Area Range Selection 2
Setting Print Area (Macro Question) 1

Top