to be honest, im hashing through this making it up as i go along, my code is
a mix of bits or recorded macro and examples from online guides,

i have no idea where the calc would have been set to manual? how do i know?

"Bob Phillips" wrote:

Does you code set the calculation mode to manual? Is so, set it back to
automatic at this time.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tigoda" wrote in message
...
I have a macro that pulls info from a work book and then pastes it in to
another sheet, at this point I need the macro to stop running so that the
formula's I have in the sheet can update there cells before the macro
resumes
and copy's the values from the updated cells and special pastes them to a
different sheet,

Currently the formulas are only running once the macro has stopped, and it
took me forever to figure this out!

Can anyone help? I really don't want to have to split the macro up in to
two
separate ones

Can you help?