Cells().Select and .Activate don't "move the camera" to that cell - how do I do this?

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...

If i understand you correct, you can use one or both of theese methods to "move the camera" or in other words, scroll to the selected cell.

Please Login or Register  to view this content.

Awesome - thanks guys.

There's no pane-freezing here - let's say:

1. The previous thing I had been doing in the macro ran from B1:B500, so the current view of the sheet would show me rows 450-500 (depending on the resolution of your monitor)
2. When I go back, I want to SEE the macro working, so I use Cells(2,1).Select, but while it selects that cell, it doesn't actually show me the .selected cell.

I'll try the ActiveWindow.Scrollcolumn / Row to see if that works.