Freeze screen during computations
 

I have a macro which does data import and does computations on varios
tabs of my spreadsheet. I cannot recall the command which prevent the
screen from flashing to various tabs as the macro progress. What is
the command to keep the screen at the tab at which it starts and not
jump around? Thanks.

Freeze screen during computations
 

Application.ScreenUpdating = False

"fmistry" wrote:

I have a macro which does data import and does computations on varios
tabs of my spreadsheet. I cannot recall the command which prevent the
screen from flashing to various tabs as the macro progress. What is
the command to keep the screen at the tab at which it starts and not
jump around? Thanks.