Macro to print and sort range

[hajiali]

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.

 

[footoo]

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