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" <JimMay@discussions.microsoft.com> wrote in message
> news:C1F9F6D9-4433-4464-9964-B7E0657BE385@microsoft.com...
> > 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