J
Joe HM
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
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