Macro help

[Dan Wilson]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (updated). I have a worksheet titles "50-69" with 16 Columns and 4,000 Rows. I have created Macros to sort this worksheet in several different ways. To make the job easier, I have moved the Control Buttons that run the Macros to another worksheet titled "Macros" that houses the Control Buttons and a description of what each Macro does. All is working well with one problem. The last line of code in each Macro is "Range("I2").Select" with different cells in the worksheet "50-69" chosen as the Select. Is there a line of code that I can use in the Macros to make the display show the newly sorted data instead of remaining in the "Macros" worksheet? Thank you for any help with this.
Dan Wilson...

 

[Herakles]

Good day. I am running Excel out of Office365 (updated) and Windows 10 Home (updated). I have a worksheet titles "50-69" with 16 Columns and 4,000 Rows. I have created Macros to sort this worksheet in several different ways. To make the job easier, I have moved the Control Buttons that run the Macros to another worksheet titled "Macros" that houses the Control Buttons and a description of what each Macro does. All is working well with one problem. The last line of code in each Macro is "Range("I2").Select" with different cells in the worksheet "50-69" chosen as the Select. Is there a line of code that I can use in the Macros to make the display show the newly sorted data instead of remaining in the "Macros" worksheet? Thank you for any help with this.
Dan Wilson...

worksheet("50-69").activate will display the worksheet with the data on it.

Range("I2").Select will select that cell on the active workbook, Macros.

 

[Dan Wilson]

Good day Herakles and thank you for responding so quickly. After some experimentation, I was able to make your suggestion work. I think I understand Macro structure a little better now.
Thanks, Dan Wilson...

 

[MARK858]

Or you can try

Application.Goto WorkSheets("50-69").Range("I2"), True

 

[Dan Wilson]

Good day MARK858 and THANK YOU for the answer that not only works, but it also fixed another problem with two of my seven Macros. And thank you for sending the suggestion even after I marked the post as completed.
Dan Wilson

 

[MARK858]

You're welcome, it was just another option to consider.