View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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 ;-)