View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Move the position of spreadsheet on the screen

"Souris" wrote in message
...
I would like to have my spreadsheet select a like like "AA12" and move this
cell to left upper of the screen.

I use sheets("sheets").Range("AA12").select

Ther cell wa selected, but it is located on any where on the screen.

I want to show user the data base on cell "AA12".

Is it posible to have my spreadsheet celll on the left upper of the
screen?


Here's one way to do it:

Application.Goto Sheets("sheets").Range("AA12"), True

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm