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?

Use this anytime you want the formulas to update.

Application.calculate

HTH,
Paul

"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?

thank you, thats simple and fast,

"PCLIVE" wrote:

Use this anytime you want the formulas to update.

Application.calculate

HTH,
Paul

"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?

it doesn't appere to work,

iv placed it just after where i paste the rows in and before i begin to copy
the in for over but its still not working the cells do not update,

"PCLIVE" wrote:

Use this anytime you want the formulas to update.

Application.calculate

HTH,
Paul

"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?

Try

Application.calculate
DoEvents

HTH. Best wishes Harald

"tigoda" skrev i melding
...
it doesn't appere to work,

iv placed it just after where i paste the rows in and before i begin to
copy
the in for over but its still not working the cells do not update,

"PCLIVE" wrote:

Use this anytime you want the formulas to update.

Application.calculate

HTH,
Paul

"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?

You can call the .Calculate method yourself on a Range, Worksheet or
Application.
Do that after your initial paste and before the copy.

NickHK

"tigoda" ...
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?

Look for "Application.ontime" in the VBA help.

This example from VBA help:

This runs a procedure 15 seconds from now.

Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"

HTH
Jo

--
LFCFa
-----------------------------------------------------------------------
LFCFan's Profile: http://www.excelforum.com/member.php...fo&userid=3748
View this thread: http://www.excelforum.com/showthread.php?threadid=57420

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?

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?