Here is a typical method:

Sub WaitABit()
' do some stuff
MsgBox ("Do your thing and set Z1 when you are done")
While Range("Z1").Value = ""
DoEvents
Wend
MsgBox ("Thanks! I will proceed")
End Sub

1. we inform the User they must take some action
2. the code just loops until Z1 has been set, but the the sheet has focus to
allow User activity
3. when the User finally set Z1 to something, the code proceeds.
--
Gary''s Student - gsnu200909


"Spike" wrote:

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