Mixed references in VBA formulas

**McNultyK** · 07-20-2011, 05:40 PM

I want to enter a formula in a column of cells on a spreadsheet. The formula needs to be entered from VBA. I can enter the formula in the top cell using, for example Range("D2").FormulaR1C1 = "= ...." I have no problem entering the formula as long as all cells in the formula are entered using relative references. However, I want some of the cells in the formula to be absolute references, so when I copy the formula down the column the absolute references continue to refer to the same cells. Is there a way to do this, and if so, how?

**TMS** · 07-20-2011, 05:48 PM

Put the formula you want to end up with in the cell, absolute and relative references as you choose.

Then record a macro, select the cell, press F2 and press Enter. Stop the recording.

That will give you the basic code which you can edit as required.

Regards