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?