CODEWITHSUNDEEP
excelvba
sotir dimovski
sotir dimovski

Reputation: 13

Excel writing formula via VBA

do you know how to write this type of Formula in Excel Cell via VBA:

Range("e15").Value = "=SUM(OFFSET(E6:E7;0;0))"

Upvotes: 1

Views: 86

Answers (1)

Rory
Rory

Reputation: 34035

You need to use US format formulas:

Range("e15").Formula = "=SUM(OFFSET(E6:E7,0,0))"

Upvotes: 1

Related Questions