Store value from an array in new variable

[vizzkid]

Can someone explain why this piece of code works

Sub Macro1()
    Dim myVector(2) As Integer
    myVector(0) = 12
    myVector(1) = 41
    myVector(2) = 3
    Call macro2(myVector)
End Sub

Private Sub macro2(ByRef myVector() As Integer)
    Range("C1").Value = myVector(2)
End Sub

But this doesnt:

Sub Macro1()
    Dim myVector(2) As Integer
    myVector(0) = 12
    myVector(1) = 41
    myVector(2) = 3
    Call macro2(myVector)
End Sub

Private Sub macro2(ByRef myVector() As Integer)
    Dim val As Integer
    Set val = myVector(2)
    Range("C1").Value = val
End Sub

I can't figure out how to store a value from the array in a new integer variable!

[Kyle123]

Private Sub macro2(ByRef myVector() As Ingeter)
    Dim val As Integer
    val = myVector(2)
    Range("C1").value = val
End Sub

You only set objects, an integer isn't an object, also you shouldn't really use function names as variable names, it makes excel confused val is a function

[:) Sixthsense :)]

You are trying to set Val as object because SET used to assign objects. Just remove the Set and try

val = myVector(2)

[vizzkid]

Thanks guys!