If you used window|freeze panes, it may not.

Jeff Standen wrote:

Without wishing to appear foolish, doesn't ctrl-home always go to A1?

"Jim May" wrote in message
...
Is there a way I can determine the .address of the cell that is the
result of the Control+Home on any sheet that I might activate (and
I have over 100 sheets)?
I'd like to incorporate it into a
Private Sub Workbook_SheetActivate(ByVal Sh As Object) ' macro

Tks in Advance

--

Dave Peterson