Given a worksheet function that accepts a range of values, Average(Range),
for example.....
What is the method to use the .formulaR1C1 method within VBA to assign the
Average formula to a cell, assuming that I want to define the formula from
within VBA using the Range/Cells method(s).
Example:
Macro recorder provides the following code to define a cell using the
Average function:
ActiveCell.FormulaR1C1 = "=AVERAGE(R[-4]C[-2]:R[12]C[-2])"
Can this be done via something like:
Dim Rindex as Integer
Dim Cindex as Integer
Rindex=3
Cindex=7
strArg= "=" & Range(Cells(Rowindex, Colindex),Cells(Rowindex+7,Colindex))
ActiveCell.FormulaR1C1 = "=" & strArg
and have it parse correctly....
i.e. I would like to be able to manipulate the .FormulaR1C1 line via
variables that get worked upon prior to setting the formula in the cell.
Thank you in advance for the assistance.
--
Frank Bachman
(Grumpy Aero Guy)
Bookmarks