I'm sure this is relatively easy but I have spent a considerable amount of time searching forums and microsoft msdn and cannot figure out how to do this.
I have two columns in an excel worksheet [a,b] which are both populated with a fixed number of values (some integer, some double). I would like to be able to have a macro that adds A1 + B1, updates column B1 with the new value, and then loops to do the same for each value in the column. I know that I need to store column A in an array and store column B in an array, but I cannot figure out the code to select one value from each array, add them, and store them in a new array.
So,
A1+B1 = B1
A2+B2 = B2
A3+B3 = B3
and so on.
I am working with data from multiple spreadsheets saved on servers so I can not just use the functions in the cells, it has to be done in VBA.
Thanks.
Bookmarks