Hi,

I use Excel for automated trading strategies and am trying to learn how to write code more efficiently for speed and ease of editing.

Here for example I would like to know if there is a significant speed difference between the two procedures?

Or Is there any way i could get an accurate timer to time my coding?
( I understand it may need to be a little more complex than these examples to get accurate readings)

Sub Efficiency()

Dim TeamPlayer1 As Integer, TeamPlayer2 As Integer, TeamPlayer3 As Integer, TeamPlayer4 As Integer, TeamPlayer5 As Integer

TeamPlayer1 = Range("D10")
TeamPlayer2 = Range("D11")
TeamPlayer3 = Range("D12")
TeamPlayer4 = Range("D13")
TeamPlayer5 = Range("D14")
End Sub

Sub Efficiency2()

Dim TeamPlayer(1 To 6) As Integer
Dim i As Integer

For i = 1 To 6
TeamPlayer(i) = Range("D" & i + 9)
Next i
  
End Sub