How to enter array formula with VBA
I determine the changed values by counting the columns to the right from M1 and then making adjustments to convert that into the
proper cell address. Once this is done, I will copy the array formula down until the cell to the right is blank.
--
RMC,CPA
"Bob Phillips" wrote in message ...
How do you determine the changed values.
The general format for array formulae is
activecell.formulaarray="=SUM(IF(RIGHT($M$1:$BC$1, 3)=""Alt"",M2:BC2,0))"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"R. Choate" wrote in message
...
I need to programmatically enter an array formula into a cell after the
ranges involved in the formula are determined. I also do not
want to use the R1C1 format. My "base" formula is
=SUM(IF(RIGHT($M$1:$BC$1,3)="Alt",M2:BC2,0)). However, the $M$1:$BC$1 and
the
M2:BC2 will change each time I place this formula into a cell. I know that
the general manner of entering an array formula is to use
syntax which begins with the word "Evaluate". Can somebody help me on this
one?
--
RMC,CPA
|