Excel Macro : Print Selected Area

3 months ago

1 min read

To use this Macro follow those quick steps:

Download this Excel File

Open it and add a custom Group “MyMAcro” to the Ribbon in Excel

Add the new Macro under the custom Group by adding a new tab

Thats it use this Macro where you want in all your workbook

Sub PrintTheSelectedArea()

'Print out a copy of your selected area
Selection.PrintOut Copies:=1

End Sub