You could loop through the two dimensional arrays something like this:

Distance = Sqr((varX(i, 1) - varXData(j, 1)) ^ 2 _
+ (varY(i, 1) - varYData(j, 1)) ^ 2)
SumDataWeights = SumDataWeights + varData(j, 1) / Distance ^ Power


Hope this helps
Rowan

" wrote:

Thanks for your quick response. Is their a way to read a range into a
variant as a one dimensional array?

Or should I loop through the cells in the range to fill the array? What
impact will this have on the speed of filling the arrays.

Thank you,
Dave