View Single Post
  #2   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 ..?

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