Get a specific row to the top of the sheet

[Jaamie]

I want to get row 100 to be at the top of the sheet. It always shows up in the middle when I select it in VBA. If I down arrow off the page, it jumps that row to the middle. I feel like I am missing something simple.

Thank you.

 

[FormR]

Try:

Sub s()
Application.Goto Range("A100"), True
End Sub

 

[Jaamie]

Thank you.

I never knew of that command, it worked great.