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

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


End Sub

"Ayo" wrote:

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

Here is a small modification to my last posting

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


End Sub


"Ayo" wrote:

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

Thanks a lot Joel. I really appreciate it.

"Joel" wrote:

Here is a small modification to my last posting

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


End Sub


"Ayo" wrote:

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

try this

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

--


Gary


"Ayo" wrote in message
...
How do I write a code to make a specific cell the top left cell in the
worksheet?