I know there is a flag I can set in code so that while a macro is running excel does not update the screen until it is done. Does anyone know what that flag is?