hi guys,i wrote a macro that wont get updated unless i can find a way to enable DDE updates while the macro is runnins. or maybe stop/sleep the macro and having it rerunning.this is an example.Sub Macro1()Dim i As IntegerFor i = 1 To 1000Do While Worksheets("sheet1").Range("pxlast").Value = Worksheets("sheet1").Range("init").Offset(i - 1, 0).Value ' this is where i need to induce sleeping or pausing or stopingLoopWorksheets("sheet1").Range("pxlast").CopyWorksheets("sheet1").Range("init").Offset(i, 0).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=FalseNextEnd SubPXLAST is =blp("ukx index", "last price")thanks indeed in advance.

i got it. thanks.there a fine example of a very good way this can be accomplished at www.xl-logic.com

What was the solution?