Help with Offset formula?

[jmthompson]

I am building a macro that includes the following lines:

Cells(lastRowWFO + 20, "E").Formula = "=(Activecell.Offset(-2,0) - Activecell.Offset(-2,-1))"
Cells(lastRowWFO + 20, "G").Formula = "=(Activecell.Offset(-2,0) - Activecell.Offset(-2,-1))"

I want to enter a formula in one cell which takes the value of the cell two rows above and subtracts the value in the cell two rows above and one column to the left. Since the location of these cells/rows will constantly change, I thought I'd use and offset function, but I'm doing something wrong.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

 

[jmthompson]

Solved with the assistance of macro recorder...

Cells(lastRowWFO + 20, "E").Formula = "=R[-2]C-R[-2]C[-1]"
Cells(lastRowWFO + 20, "G").Formula = "=R[-2]C-R[-2]C[-1]"

note to self: get some sleep and stop overthinking things