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.

Excel 2003 Screen View
 

Hi Gene,

Try:

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

---
Regards,
Norman



"Gene Mills" wrote in message
. ..
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.