| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("A1").Select
Hi,
I know how to get the cuser to move to cell A1, but how do I get the screen to display A1. My problem - I'm at cell Z100 and I use Range("A1").Select BUT it returns the cursor to A1, but leaves me looking at the middle of the spreadsheet at Z100 still. How do I get the screen to display the the page with A1 reset back to the top left? Tks, Kaye |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range("A1").Select
Hi Rick
ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Regards, OssieMac "Rick" wrote: Hi, I know how to get the cuser to move to cell A1, but how do I get the screen to display A1. My problem - I'm at cell Z100 and I use Range("A1").Select BUT it returns the cursor to A1, but leaves me looking at the middle of the spreadsheet at Z100 still. How do I get the screen to display the the page with A1 reset back to the top left? Tks, Kaye |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range("A1").Select
Thanks OssieMac! Kaye (on Rick's computer) On Thu, 11 Oct 2007 00:26:02 -0700, OssieMac wrote: Hi Rick ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Regards, OssieMac "Rick" wrote: Hi, I know how to get the cuser to move to cell A1, but how do I get the screen to display A1. My problem - I'm at cell Z100 and I use Range("A1").Select BUT it returns the cursor to A1, but leaves me looking at the middle of the spreadsheet at Z100 still. How do I get the screen to display the the page with A1 reset back to the top left? Tks, Kaye |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range("A1").Select
application.goto Range("A1"), scroll:=True
is another way. -- Regards, Tom Ogilvy "Rick" wrote: Thanks OssieMac! Kaye (on Rick's computer) On Thu, 11 Oct 2007 00:26:02 -0700, OssieMac wrote: Hi Rick ActiveWindow.ScrollRow = 1 ActiveWindow.ScrollColumn = 1 Regards, OssieMac "Rick" wrote: Hi, I know how to get the cuser to move to cell A1, but how do I get the screen to display A1. My problem - I'm at cell Z100 and I use Range("A1").Select BUT it returns the cursor to A1, but leaves me looking at the middle of the spreadsheet at Z100 still. How do I get the screen to display the the page with A1 reset back to the top left? Tks, Kaye |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range("Reset Sheet!F13").Select Makes VBA Code Fail | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| How do I select a range of cells without doing Range("a3", "f3").. | Excel Programming | |||
| VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
![Rick[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
