Hello

I have posted my issue before but a colleague has the same issue. We have
macros which run some code including a refreshall. The refeshall does not
complete before the macro goes to the next step and this causes it to crash
or not work correctly.

what step could i put in the code so that it waits until the refresh is
complete before going onto the next bit. a time break would not work because
the refresh can take different amounts of time depending on where you are
refreshing it.

my code:

Sub Refresh_all_Button_Click()
   ActiveWorkbook.RefreshAll
   MsgBox ("Refresh is complete")
   Range("k2").Select
   ActiveCell.FormulaR1C1 = "=TODAY()"
End Sub

Thanks