Use r1c1 if you need to enter relative references

Range("A1:A10").FormulaR1C1 = "=IF(RC[1]3,RC[2],RC[3])"




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Anders Lindén wrote :

hm, do you know how to express an IF(;;) function with .formula then?

Or did I misunderstand your point?

/Anders