Disregarding the actual formula, it needs to be applied to the ActiveCell AS
WELL AS
the second, third, and fourth columns to the right ...

ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,R[-3]C:R[-1]C)+R[-4]C"

Is there an array that will select - paraphrased - ActiveCell.Offset r-0
c-0,2,3,4, or something like that??

Any assistance is greatly appreciated.
Regards,
- Mike

In Excel, formulas return values to the cell in which the formula resides.
It cannot perform selections as in VBA, but it can use a specific range of
cells to perform calculations. You cannot use variables in Excel formulas
that are manually entered but you can use named ranges.

"MikeF" wrote:


Disregarding the actual formula, it needs to be applied to the ActiveCell AS
WELL AS
the second, third, and fourth columns to the right ...

ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,R[-3]C:R[-1]C)+R[-4]C"

Is there an array that will select - paraphrased - ActiveCell.Offset r-0
c-0,2,3,4, or something like that??

Any assistance is greatly appreciated.
Regards,
- Mike