Update Screen Location based on cell address

Anyone know the right code to make Excel update the screen location based on a cell refrence? Example: I have a macro that simply references a cell in my spreadsheet. Range("A100").Select. When I run the macro, Excel selects cell A100 but the first cell in the screen is cell A81. I want the first cell in the screen(top left cell) to be A100 so my charts to the right line up right. I know you can use the ActiveWindow.SmallScroll Down:=56 or whatever but I have multiple locations thoughout the worksheet, all with different spacing.

Have a look at the ScrollRow and ScrollColumn properties in Help.

Exactly what I needed! Thanks shg

Another method that will place A100 at the top, left of your worksheet...

Application.Goto [a100], True