Perform Mathmatical Functions on an Excel VBA Array

[JStellato]

Hello I want to populate an array with 2 columns and an unknown number of rows from an existing worksheet. If A:1 + B:1 = 5 then I want the values of the array and the total to be output to a new worksheet in Fields A:1-C:1

I've never worked with arrays in this manor before in this manor and have no idea where to even start.

Thanks for any help!

 

[crimson_b1ade]

can you provide more examples? the example provided is quite ambiguous (at least to me anyway).