insert formula vba

[HOMMER]

when I select a cell how do i put a formula in that cell???
how do i put a formula here =a1+a2


Sheets("2%M&quot.Select
Range("d42&quot.Select
ActiveCell.FormulaR1C1 = how do i put a formula here
Range("d44&quot.Select
ActiveCell.FormulaR1C1 = how do i put a formula here

 

[Dreamboat]

Here's a couple of descriptions:

"=R[5]C[6]*R[-9]C[-6]"

R[5]C[6]
This means 5 cells down and 6 columns to the right of the selected cell.

R[-9]C[-6]
This means 9 cells up and 6 columns to the left of the selected cell.

R[5]C[-6]
This means 5 cells down and 6 columns to the left of the selected cell.

And you can just enter one line, like this:

Range("A2&quot.FormulaR1C1 = "=R[6]C[1]/R[-1]C[19]"

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[dsi]

To specifically address cells:

Range("A3").Formula = "=A1+A2"

 

[HOMMER]

thanks