Posted to microsoft.public.excel.programming

Rick[_3_]

external usenet poster

Posts: 11

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Range("Reset Sheet!F13").Select Makes VBA Code Fail	ToferKing	Excel Programming	3	July 11th 07 04:18 AM
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"	Luc[_3_]	Excel Programming	2	September 28th 05 08:37 PM
How do I select a range of cells without doing Range("a3", "f3")..	Miriam	Excel Programming	2	December 20th 04 11:30 PM
VBA error 1004 "Select method of Range class failed"	Matt J	Excel Programming	6	July 3rd 04 10:05 PM
Using "Cells" to write "Range("A:A,H:H").Select"	Trip Ives[_2_]	Excel Programming	3	June 5th 04 03:13 PM

All times are GMT +1. The time now is 09:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us