View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default How to determine whether Cell is in current view?

Hello -

I would like to figure out if a certain cell is currently shown in the
current view. For instance, the excel window only displays rows 20-30
and the desired cell is in row 40 then I want to use a
ActiveWindow.ScrollRow = 40 command to make it visible.

I realize that I could just call .Select on the cell but I don't want
to move the current selection.

I found the ActiveWindow.VisibleRange function but how can I determine
from that information whether a certain cell is in the visible range?

Thanks!
Joe