-
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
-
Re: Data Arrays
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