1 2 3 4 5 | Range("A1").Value = "=B1+ 10 " Range("A1").Formula = "=B1+ 10 " Range("A1").Formula = "=B1+C1" Range("A1").Formula = "=RC[ 1 ]+RC[ 2 ]" Range("A1").FormulaR1C1 = "=RC[ 1 ]+RC[ 2 ]" |
1 2 3 4 5 | Range("A1").Value = "=B1+ 10 " Range("A1").Formula = "=B1+ 10 " Range("A1").Formula = "=B1+C1" Range("A1").Formula = "=RC[ 1 ]+RC[ 2 ]" Range("A1").FormulaR1C1 = "=RC[ 1 ]+RC[ 2 ]" |