Thread: Excel 2003 Screen View

I have worked with excel vba for several years now and have never been able
to find out how to have a cell appear directly in a certain location in the
screen. Like I want [B675] to appear in the top left corner of the
application screen right under the column headings.

Hi Gene,

Try:

Application.Goto Reference:=Range("B675"), Scroll:=True

---
Regards,
Norman



"Gene Mills" <oletrol@woh.rr.com> wrote in message
news:tZHGf.95808$Q11.61847@tornado.ohiordc.rr.com...
>I have worked with excel vba for several years now and have never been able
>to find out how to have a cell appear directly in a certain location in the
>screen. Like I want [B675] to appear in the top left corner of the
>application screen right under the column headings.
>