Help with code please !!!

[Ayo]

How do I write a code to make a specific cell the top left cell in the
worksheet?

 

[Joel]

Sub myscroll()
ActiveWindow.ScrollRow = 10
ActiveWindow.ScrollColumn = 22


End Sub

 

[Joel]

Here is a small modification to my last posting

Sub myscroll()
ActiveWindow.ScrollRow = Range("D5").row
ActiveWindow.ScrollColumn = Range("D5").column


End Sub

 

[Ayo]

Thanks a lot Joel. I really appreciate it.

Here is a small modification to my last posting

Sub myscroll()
ActiveWindow.ScrollRow = Range("D5").row
ActiveWindow.ScrollColumn = Range("D5").column


End Sub

 

[Gary Keramidas]

try this

Application.Goto Range("G35"), scroll:=True