Hi all,

I am in my spreadsheet and attempting to automate it. I want to plac
a formula in (for example) cell D3 which says =C3*B3.
I have the following line of code where D3 is the Active Cell:

ActiveCell.Formula = "=RC[-1]*RC[-2]

and it works

However I then want a formula in E3 to say C3-C2.

My question is how to reference cell C2 if RC[-2] refers to C3 an
RC[-3] refers to B3.

Hope I've made myself clear

Many thanks

Seamu

--
Message posted from http://www.ExcelForum.com