You can insert this snippet in where you need to pause. It will operate on
tenths of seconds as well as whole seconds. i.e. 1 for whole, 0.1 for
tenths.

s = Timer + 0.5
Do While Timer < s
DoEvents
Loop

The DoEvents allows other activity to process during the macro pause.


"Spike" wrote in message
...
I have a spreadsheet with some Reutes Wealth Manager formulas. I wish to
change the RIC code in some of these cells and then check if the code is
valid. For this i need to pause the macro while the cell/s update.

If i use Application.wait then everything pauses and the cells do not
update. I guess i need to find out what the code is to refresh the
Reuters
links

Any ideas will be gratefully recieved
--
with kind regards

Spike