excelguru88
New Member
- Joined
- Feb 1, 2018
- Messages
- 4
Hey guys -
I need to be able to set print area using named ranges that vary dynamically.
For example, I have 4 named ranges and they are:
Range1
Range2
Range3
Range4
Now in one scenario, I want the PrintArea to be set to = Range1,Range3
In another scenario, I want the PrintArea to be set to = Range2,Range3
...and so on
Now, I can manually update the print area to the two scenarios above, but how can I do that using a formula or VBA?
Any thoughts would be helpful.
I need to be able to set print area using named ranges that vary dynamically.
For example, I have 4 named ranges and they are:
Range1
Range2
Range3
Range4
Now in one scenario, I want the PrintArea to be set to = Range1,Range3
In another scenario, I want the PrintArea to be set to = Range2,Range3
...and so on
Now, I can manually update the print area to the two scenarios above, but how can I do that using a formula or VBA?
Any thoughts would be helpful.