Setting the view area
 

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

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio

Setting the view area
 

try
Sub setviewablearea()
Application.Goto Range("e6"), scroll:=True
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Ciaccio" wrote in message
...
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

--
Jeff Ciaccio
Physics and AP Physics Teacher
Sprayberry High School; Marietta, GA
Blog: http://sprayberry.typepad.com/ciaccio

Setting the view area
 

Perfect! Thanks.
- Jeff

Setting the view area
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Ciaccio" wrote in message
...
Perfect! Thanks.
- Jeff