Sub abc()
Dim MyArray(3) As Integer
MyArray(1) = 1
MyArray(2) = 2
MyArray(3) = 3
MsgBox MyArray(1) & MyArray(2) & MyArray(3)
Z = MyArray(3)
MyArray(3) = MyArray(1)
MyArray(1) = Z
MsgBox MyArray(1) & MyArray(2) & MyArray(3)
End Sub
see if it wrks
On Wed, Nov 13, 2013 at 10:28 AM, Pavan Vallu
Guyz Can i know how to reverse ana array in VBA. I am passing values like
MyArray(1) = 1,MyArray(2) = 2,MyArray(3) = 3
But i need to reverse that array without using loop. Is there any direct
function to reverse it? i need output like MyArray(1) = 3, MyArray (2)= 2 &
MyArray(3) = 1.
Thanks in A
