VBA formula Property help!

[usher.smith1]

Thanks in Advance! Okay guys, I have spend a whole day trying to figure this thing out but no luck I think I'm done with part 1 and 2, but I have no clue what to do with part 3. I know I'll have to use activecell.formula, but I'm not getting anywhere. I'm attaching the file as well. The questions that I'm trying to solve for my problems are as follows:

1. The excel has sales totals for 12 months and 10 different products in the range B4:M14, write a VBA sub to enter formulas for the total in column N and row 14. Use R1C1 property to write formula.

2. Repeat previous exercise, but now assume the data set could change, either by adding more months or adding products, or both. Using Formula R1C1, fill the row below data and the column to the right of the data with formulas for totals. (Hint, use string concatenation)

3. Do the previous two exercises by using "formula" property, rather than formulaR1C1 property.

Please Login or Register  to view this content.

[protonLeah]

Excel Developer Reference

Range.Formula Property
-----------------------------------------
Returns or sets a Variant value that represents the object's formula in A1-style notation and in the language of the macro.

Syntax:

expression.Formula

expression: A variable that represents a Range object.

Remarks:

If the range is a one- or two-dimensional range, you can set the formula to a Visual Basic array of the same dimensions. Similarly, you can put the formula into a Visual Basic array.
Setting the formula for a multiple-cell range fills all cells in the range with the formula.

Example: This example sets the formula for cell A1 on Sheet1.

Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"