Inserting Formula to a cell from VBA using Array References

**dougman824** · 06-16-2017, 02:10 PM

Hello,

I am trying to create a function for a cell from VBA.

I have all of the cells addresses I would like to add together stored in an array. (they are not all joined together but rather every third cell in a column )

I would now like to have the formula be entered to the cell as =sum(array(1)+array(2) ect)

I am looking for the code so I can just have all of theses come in without having to code it like

Please Login or Register  to view this content.

I have 30 cell references so I would really like to not have to type this out 30 times, especially since I plan on using this code to fill more than 100+ cells

**AlphaFrog** · 06-16-2017, 11:02 PM

Originally Posted by dougman824

=sum(array(1)+array(2) ect)

Using both the SUM function and the Plus operator is redundant. Just use one or the other e.g.;
=SUM(array(1),array(2), ect)
Or
=array(1) + array(2) + ect

As far as your query, I'm not sure what you're asking.
This will concatenate each value in the array with a Plus delimiter...

Range("A1").Formula = "=" & Join(Array, "+")