Can a Chart update as a running macro updates cells?

[JeffFinnan]

I would like to be able to run a macro that updates some cells such that as each cell is updated a chart is updated too. Presently the chart does not update until the macro has completed. Here is code I am using. I put in the delay to allow for the chart to update or at least that was my thinking.

Sub CopyPasteDate()
'
' CopyPasteDate Macro

    Range("BF6").Select
    Selection.Copy
     
    For i = 7 To 40
      Range("BF" & i).PasteSpecial Paste:=xlPasteFormulas
      Application.Wait (Now + TimeValue("0:00:02"))
    Next i

  Application.CutCopyMode = False
   
   
End Sub

Is there way to achieve what I would like to do?

Thanks,
Jeff

 

[JeffFinnan]

After much playing around I had to revamp. I got this code to work for me. It is slow enough that I did not need to add any wait time.

Sub beachDistDynamic()
'
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

    j = 2
    For i = 4 To 30
        Worksheets("GTM Data  2022").Range("BF" & i).Formula = "=ActivityReport!$H" & j
        Sheets("Beach Dist 2022").Activate
        j = j + 1
        DoEvents
    Next i
    
End Sub

If there is a better way, let me know.