Summing the values of a generated array.

Hi,

I'm writing a macro which has to insert a formula into a cell (TopCell) which adds some other cells up.

The addresses of these other cells have already been generated using VBA into an array within the program (I don't want to have to add new worksheets to the project). The array can be different lengths (i.e. difference numbers of cells) depending on the point in the spreadsheet.

I want to know how to get excel to insert a formula into the TopCell which adds up all the cells it finds in the array. - I.e. in the TopCell i want to see

=Sum(A1,A2,A3....End of array)

Cheers,
Jo

Please Login or Register  to view this content.

thats brilliant thanks!