I need to create a pause in my Macro to give the workbook time recalculate.

How about just putting:

Application.calculate
or
application.calculatefull

where you want.

But doesn't your macro just wait for it to finish calculating before going to
the next line (assuming calculation is set to automatic).



Robert L wrote:

I need to create a pause in my Macro to give the workbook time recalculate.

--

Dave Peterson