MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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