I'm working on a big spreadsheet, and I want the selected box to "be in the vision of" the person looking at the screen.

The macro I'm writing works fine - it selects the correct cell, but it doesn't - for lack of a better word - move the "camera" onto that cell. If the sheet is set to view rows 500 - 540, and I'm working on cell B5 - using something like Cells(2,5).Select will work to select B5, but not to change the focus of the sheet away from where it currently is over to where the macro is running.

This is horribly explained, I'm tired... but hopefully this makes sense to someone...