Hi, apologies for such a basic question.

I have a macro which gathers results from various places in a large sheet and value-pastes them into a table.

To prevent the user from getting seasick while the macro runs, I know I can use the

application.screen updating = false

command, but this does a bit more than what I want.

I want the user to see the results appearing in the table, without subjecting him or her to a fast-motion view of the screen jumping around. So instead of turning updating off altogether, is there a way I can tell Excel to hold the current screen frame while the macro runs? The result should just look like a screen which is static, except that the results can be seen being added to the table.

I'd be grateful for any help.