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