Setting the view area

[Jeff Ciaccio]

I would like to set a certain cell at the upper left portion of the viewable
area. I have tried range("E1").select, bu this does not guarantee that E1
will be in the upper left of the viewable area.

Any suggestions?

Thanks

 

[Don Guillett]

try
Sub setviewablearea()
Application.Goto Range("e6"), scroll:=True
End Sub

 

[Jeff Ciaccio]

Perfect! Thanks.
- Jeff

 

[Don Guillett]

Glad to help