"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