Prevent Worksheet Recalculation with Macro that Pastes

I currently have a Macro which searches a range for blank cells, selects all non-Blank cells within that range and Copies them. I have another Macro which Pastes them. Several of the cells that I copy include =Randbetween(0,99), and as soon as my Paste macro performs its Paste operation, all of my Randbetweens re-roll. The Randbetweens come from a different sheet, so I'd like to prevent all cells/processes from updating on the entire document, not just one sheet.

How can I prevent this macro from triggering an update/recalculation?

Please Login or Register  to view this content.

And for reference, the PasteValues is

Please Login or Register  to view this content.

But don't forget to put it back on after ....your code

Please Login or Register  to view this content.

I could cry, then I could bake you a cake....

All it took was adding the xlCalculationManual abefore it.

Thank you thank you thank you!

I have a few other macros that use my PasteValues macro, so I condensed it so split it among the four other macros that use it for their respective sheets.