Adding Row Values in an Array: VBA

Question

I'm building a Genetic Algorithm in VBA and my fitness function depends on how many 1's the array row has. The array is a combination of 1's and 0's. The Array can be any size (2D) and I need to add the number of 1s in the row and compare it to the rest of the values. I was considering finding the max value of 1s and comparing it the min values of 1 in the array and moving forward from there, but I'm not sure if this is the best way to do this.

If you guys could give me some tips on how to do this that would be great! Or if there are some array addition functions that I'm missing in VBA.

Answer 1

Another approach would be to use Excel's SUM() function to do the work. Summing the array would give you the same answer as counting the ones, and you can use the Application.WorksheetFunction object to give you access to SUM():

x = Application.WorksheetFunction.Sum(aArray)