Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ;-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ;-) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ;-) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ;-) | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Macro to take selected cells times a selected cell | Excel Programming | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | Excel Programming |