Microsoft Excel - Macros for auto scroll?

Is there a way to make a macros attached to a graphic that when activated will automatically find a specific cell and scroll to it.....or is there a better way to do this? BTW - I have Excel 2003.

Hi Cara

Use the Goto Method as below.. which selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.

expression.Goto(Reference, Scroll)

expression    Required. An expression that returns an Application object.

Reference    Optional Variant. The destination. Can be a Range object, a string that contains a cell reference in R1C1-style notation, or a string that contains a Visual Basic procedure name. If this argument is omitted, the destination is the last range you used the Goto method to select.

Scroll    Optional Variant. True to scroll through the window so that the upper-left corner of the range appears in the upper-left corner of the window. False to not scroll through the window. The default is False.

'in the same sheet
Application.Goto Range("A10"),True


Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), Scroll:=True

hi,

here are some good links for this

http://en.allexperts.com/q/Excel-1059/2010/7/auto-scroll-results-2.htm
http://www.excelforum.com/excel-programming/634555-auto-scroll-of-worksheet.html

hope this will help you