Data Arrays

Hope some can help, its a bit of a big one! I am new to coding and I am trying to work out to use a 2 dimensional data array to have a list of numbers in one column that need converting to a different set of numbers in the second column. So A1 will be converted to value in B1 and A2 to B2 etc. I hope some can help since none of the books say how to do this at all! (Dummies book and the MS step by step). Thanx in advance

Vivek, try this

for i=1 to ubound(aa,1)
aa(i,2)=computenewvalue() 'computenewvalue() is expected to return the value
next



also assume that aa has been declared appropriately and option base setting is 1