Macro to sum of all the row of a named range and store in a single dimensional array

Hi,

I have been using excel macro via macro recorder. However, I have an unique problem in hand where I require vba language hand ons. The issue is as under:

I have defined two named ranges: 1) Forecast 2) Actual

Now what I am looking for is a macro that would sum each row of forecast and each row of actual separately and take the absolute of these two sums and then store them in a array for further calculations.

To explain it further it would be like:
Absolute(Sum of row 1 of Actual - Sum of row 1 of Forecast) and then store the result in the first row of array
...repeat for n number of rows (as defined during naming the two tables)

Hope I am able to explain. Please let me know if there's further info required.


Rgds qomarf

Hey Alpha,

Thanks! I worked my way from your codes. One last question- how do you turn this into formula i.e. Function ()? For example I want see the sum of the Absolute array by entering formula into a cell example: by inserting "=Testformula()" in any cell within the workbook where I have created the module will give me the sum of Absolute array.

Rgds Qomarf

The issue has been addressed and solved.