Help with macro

[Russk68]

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

 

[Tetra201]

There is -- try

Sub Macro1()
    Rows("$10:$18").Hidden = True
End Sub

 

[Russk68]

Awesome!
Thank you

 

[Tetra201]

You are welcome.

Happy New Year!