ScrollIntoView Non-Selected Cell ..?

[Andrew]

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 ;-)

 

[JLGWhiz]

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.

 

[JLGWhiz]

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]

Thx JLGWhiz..

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




| 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.
|
|
|
| | > 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 ;-)
| >
| >
|
|