| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting the view area
Perfect! Thanks.
- Jeff |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting the view area
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jeff Ciaccio" wrote in message ... Perfect! Thanks. - Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chnge view order, Area chrt? | Charts and Charting in Excel | |||
| Limiting view area to user | Excel Programming | |||
| Setting print area with vba | Excel Programming | |||
| Limiting view area to user | Excel Programming | |||
| setting print area via VBA | Excel Programming | |||
Linear Mode
