Delay Macro

Hello Jazzy Max,

This macro will load the values at 1/2 second intervals.

Sub SlowLoad()

  Dim Cell As Range
  Dim Interval As Single
  Dim StartTime As Single
  
    For Each Cell In Range("A2:A9")
      Interval = 0.5
      StartTime = Timer
        Do While Timer < StartTime + Interval
          DoEvents
        Loop
      Cell.Offset(0, 1) = Cell
    Next Cell
    
End Sub