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