Help hiding macro work

[Guest]

I have workbook where most of my data is entered on one sheet.
When the data has been entered, I press a macro button that copies and
pastes the values of the cells into other parts of the workbook. Is there a
way that when the macro is run, you can hide all the sheets from flashing on
the screen while completing the tasks?

Thanks

 

[Norman Jones]

Hi JustaGuyFromKY"

Top your code with the line:

Application.Screenupdating = False

and tail it with the converse line:

Application.Screenupdating = True

You can normally reduce/eliminate the flicker by removing select actions
from your code. Such selections are usually unnecessary and tend to slow
processing.