i have an array (0 to 10000, 0 to 63) which i'm sorting based on a value in the second index
so i need to be able to switch values based on the first index. ie Array(0) = Array(1) and this would take all values that have 1 as the first index. This is possible in other languages but gives me a 'subscript out of range' error in vba.
is there a way around this?
Thanks in advance,