Print Macro for Range Names
Posted by David Wicker on October 24, 2001 2:21 PM
Many years ago in 123 I used to use /range/name /create quite a lot for creating ranges, sometimes for printing
In excel I never seem to have made a happy transition to "set print are"
In a macro, how do you select a specific range to print?
Many thanks in advance
David
Posted by Bob Umlas on October 24, 2001 4:16 PM
Range("Whatever").Name="Print_Area"
Posted by Liam Brady on October 24, 2001 4:24 PM
I got the following with help from the macro recorder :-
ActiveSheet.PageSetup.PrintArea = YourSpecificRange.Address
