How to make a cell appear in upper left (top left) corner of works
 

Whenever I use the Range("A28").Select command, it selects and makes A28 the
focus, but it puts appears in about the the middle of the worksheet, with
rows visible both above and below it.

How do I select A28, AND move A28 up to the top left corner of the sheet, so
there are only the rows below it visible?

Thanks

How to make a cell appear in upper left (top left) corner of works
 

One way:

Option Explicit
Sub testme()
Application.Goto ActiveSheet.Range("a28"), scroll:=True
End Sub



jeff wrote:

Whenever I use the Range("A28").Select command, it selects and makes A28 the
focus, but it puts appears in about the the middle of the worksheet, with
rows visible both above and below it.

How do I select A28, AND move A28 up to the top left corner of the sheet, so
there are only the rows below it visible?

Thanks

--

Dave Peterson

How to make a cell appear in upper left (top left) corner of w
 

Excellent!!! Thank you

"Dave Peterson" wrote:

One way:

Option Explicit
Sub testme()
Application.Goto ActiveSheet.Range("a28"), scroll:=True
End Sub



jeff wrote:

Whenever I use the Range("A28").Select command, it selects and makes A28 the
focus, but it puts appears in about the the middle of the worksheet, with
rows visible both above and below it.

How do I select A28, AND move A28 up to the top left corner of the sheet, so
there are only the rows below it visible?

Thanks

--

Dave Peterson