Macro to print and sort range

hajiali

Board Regular
Joined
Sep 8, 2018
Messages
192
Office Version
2016
Platform
Windows
Hello all not sure if what im needing is quite possible.

Im needing a Macro to Sort a range and Print it without haveing to Sort the actual excel. Just need the Sorting to occur for print purposes not to effect the actual excel.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,012
Office Version
2016
Platform
Windows
Here's a possibility which you can try creating with the macro recorder:
• Make a copy of the sheet
• Sort the sheet copy
• Print
• Delete the sheet copy
 

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top