Macros and VBA

I'm trying to move a specified row to the top of the screen. This seems to be easy enough but when I "select" a cell that I want to be on top, it appears somewhere else. Even when I just page down (s...

Macros and VBA

HansVogelaar
Nov 26, 2020
Frank Drucker

You can use Application.GoTo with True as second argument. For example, to scroll cell A20 on the active sheet to the top:

Application.Goto Range("A20"), True

It even works with a cell on another sheet. That sheet will be activated. To scroll cell A20 on Sheet2 to the top:

Application.Goto Worksheets("Sheet2").Range("A20"), True

HansVogelaar

MVP

Nov 26, 2020

Frank Drucker

You can use Application.GoTo with True as second argument. For example, to scroll cell A20 on the active sheet to the top:

Application.Goto Range("A20"), True

It even works with a cell on another sheet. That sheet will be activated. To scroll cell A20 on Sheet2 to the top:

Application.Goto Worksheets("Sheet2").Range("A20"), True

Frank Drucker
Copper Contributor
Nov 26, 2020
HansVogelaar
That worked.

Thanks for your help.
Frank

Forum Discussion

Macros and VBA