Hi All
I have a simple module assigned to a button that hides 5 rows and I also have a split widow. So when I am in row 300 or so and I use the macro, it selects cell A10 and scrolls to the top of the window. I know that I can tell what cell to be selected in the code. Is there a way to leave me in the selected cell after the macro is ran?
Thank you!
Sub Macro1()
Rows("$10:$18").Select
Selection.EntireRow.Hidden = True
End Sub
I have a simple module assigned to a button that hides 5 rows and I also have a split widow. So when I am in row 300 or so and I use the macro, it selects cell A10 and scrolls to the top of the window. I know that I can tell what cell to be selected in the code. Is there a way to leave me in the selected cell after the macro is ran?
Thank you!
Sub Macro1()
Rows("$10:$18").Select
Selection.EntireRow.Hidden = True
End Sub