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.