I've been using the following VBA to print worksheets where the print area remains constant.
What I need now is a macro that will print the selection instead of a static print area.![]()
Sub PrintTastic() With ActiveSheet.PageSetup .PrintArea = "$A2:$C17" .CenterHorizontally = True .CenterVertically = True End With ActiveSheet.PrintOut: End Sub
Any ideas?
Bookmarks