Hi I am trying to create a macro that will automatically highlights my current range (its dynamic and changes based on subtotals i select) and make it my "Print Area"
what i do now is; select g1:a1**, then shift&Ctrl&down arrow
**Note- I select g1 first, then though a1 because i have a continous column in G and not in a, so this allows me to select the entire range when i shift,ctrl, arrow down..**
the problem is..when i look at the macro its has a1:g37 as the print area (based on that particular sized range at that moment i created the macro)
I need something that can select my current range (whatever it is at the time and make THAT my new print area when i run this macro
any ideas. thanks. Max
what i do now is; select g1:a1**, then shift&Ctrl&down arrow
**Note- I select g1 first, then though a1 because i have a continous column in G and not in a, so this allows me to select the entire range when i shift,ctrl, arrow down..**
the problem is..when i look at the macro its has a1:g37 as the print area (based on that particular sized range at that moment i created the macro)
I need something that can select my current range (whatever it is at the time and make THAT my new print area when i run this macro
any ideas. thanks. Max