ScrollIntoView Non-Selected Cell ..?
 

How do i..

Without selecting it.. ScrollIntoView a Cell.. Say... R120C140
...?

ActiveWindow.ScrollintoView .. but how to find the Document Coords in
Pixels of that Cell ..? when Rows/Columns are uneven sized ..?


Any Feedback would be Appreciated..
Andrew ;-)

ScrollIntoView Non-Selected Cell ..?
 

sub dk()
ActiveWindow.ScrollRow = 120
ActiveWindow.ScrollColumn = 140
End Sub

This would put row 120, column 140 in the upper left corner of the screen.


"Andrew" wrote in message
...
How do i..

Without selecting it.. ScrollIntoView a Cell.. Say... R120C140
..?

ActiveWindow.ScrollintoView .. but how to find the Document Coords in
Pixels of that Cell ..? when Rows/Columns are uneven sized ..?


Any Feedback would be Appreciated..
Andrew ;-)

ScrollIntoView Non-Selected Cell ..?
 

P.S. The pixels are measured against the display screen surface and not
against the worksheet. There is no method that I know of to accurately
measure anything in relation to the grid of a worksheet. You can use the
Top and Left methods, or the Upper Left Corner method, but these are
relative measurements based on a configuration that is subject to change.
Excel is not really a graphics application.



"Andrew" wrote in message
...
How do i..

Without selecting it.. ScrollIntoView a Cell.. Say... R120C140
..?

ActiveWindow.ScrollintoView .. but how to find the Document Coords in
Pixels of that Cell ..? when Rows/Columns are uneven sized ..?


Any Feedback would be Appreciated..
Andrew ;-)

ScrollIntoView Non-Selected Cell ..?
 

Thx JLGWhiz..

Thats exactly what was looking for
.... ;-)




"JLGWhiz" wrote in message
...
| P.S. The pixels are measured against the display screen surface and
not
| against the worksheet. There is no method that I know of to
accurately
| measure anything in relation to the grid of a worksheet. You can
use the
| Top and Left methods, or the Upper Left Corner method, but these are
| relative measurements based on a configuration that is subject to
change.
| Excel is not really a graphics application.
|
|
|
| "Andrew" wrote in message
| ...
| How do i..
|
| Without selecting it.. ScrollIntoView a Cell.. Say... R120C140
| ..?
|
| ActiveWindow.ScrollintoView .. but how to find the Document
Coords in
| Pixels of that Cell ..? when Rows/Columns are uneven sized ..?
|
|
| Any Feedback would be Appreciated..
| Andrew ;-)
|
|
|
|