I'm wanting to input a formula (and not a value) into the activecell, which adds the first cell to the left and right of the activecell e.g. if my activecell was B1 the formula would be

**What I'm wondering is, is it possible to generalise the above, that is, if my activecell was E1 the formula that vba would insert would be "=D1+F1" or if it G1 the formula inputed would be "=F1+H1" and so on... ?**

*"=A1+C1"*

...something kinda along these lines

**activecell = "=[cell, left of activecell] + [cell, right of activecell]"**

Any help or suggestions would be greatly appreciated.

Thanks,

Lochnagar