Arrays

[tiredofit]

Can someone please explain why this is fast:

    Dim DIC As Object
    Set DIC = CreateObject("Scripting.Dictionary")

    Dim MyArray() As Variant
    
    MyArray() = wksOutputForecast.Cells(2, 1).CurrentRegion.Resize(, 1).Value
    
    Dim n As Long
    
    For n = 1 To UBound(MyArray, 1)
        
        DIC.Item(MyArray(n, 1)) = 0
        
    Next n

yet this is slow:

DIC.Item(MyArray()(n, 1)) = 0

Thanks

 

[RoryA]

I think the latter is effectively duplicating the entire array as a temporary variable before accessing one element of it.

 

[tiredofit]

Thanks