Controlling print-outs

[Dan Wilson]

Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125 columns to each row. The various Macros are used to find out the highest usage of activity. The end result is that perhaps the first 10 or 15 Rows of a sorted worksheet is all that will be needed for the purpose of awarding prizes. Is there a way to create a Print Area within a Macro so that each time a sort is done, the Print Area will change? Any help will be appreciated.
Thank you,
Danno...

 

[Paul Ked]

Hi

Yes, but when you say change, from what to what?

 

[Dan Wilson]

Good day Paul Ked. Thank you for responding. When a new sort is done via Macro, I would like the Macro to set the Print Area for that worksheet to show a particular area of the worksheet. For instance, if the sort shows ten people who had the most activity for a year, I would like the Print Area to show the first ten rows of the worksheet along with the first few Columns. The Print Area will be different on other worksheets. I realize that while creating the Macro, I could have included the Print Area selection. Now that all of the Macros are completed, I would like to insert the modified Print Area selection into each particular Macro rather than re-create all the Macros from scratch.
Thank you,
Danno...