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