Copying Formula

[Lubna Khan]

How do we copy a formula when it goes this way:

d17/d2*4.38
d18/d2*4.38
d19/d2*4.38
means the first variable keeps changing,, the rest remain the same, i cant recall!!

 

[DonkeyOte]

=$D17/$D$2*4.38

Check out absolute and relative cell referencing in XL help.

 

[Guanjin Peter]

assuming A1:A3

range("a1:a3").formula = "=d17"

result: =d17, =d18, =d19

range("a1:a3").formula = "=$d$17"
result: =d17, =d17, =d17

 

[Stormseed]

Peter, why do you want to complicate the solution to that question combining it with VBA ?

 

[Guanjin Peter]

whoops sorry. I'll take note next time.

 

[takyar]

For the cell that changes relatively, don't do anything and for the cell that remains same just put $ before the column and $ before the row number.

Examle, d17/$d$2*4.38.