CODEWITHSUNDEEP
vbaexcelrangeformula
Marc L
Marc L

Reputation: 887

Issue with using range.formula in VBA

I have a problem in that when I the following code it does not show in the cell

wbNew.Sheets("Sheet1").Range("g2").Formula = "=SUMPRODUCT('P C'!C2:j2;>[t1.xls]input!g14:n14)*E2"

If I place the formula directly into the cell the formula works perfectly. When I place it into the cell I just get a blank cell and no result

Upvotes: 0

Views: 1827

Answers (1)

barrowc
barrowc

Reputation: 10689

If you are using a version of Excel other than American English, you may want to get and set the FormulaLocal property of the Range object instead of the Formula property. FormulaLocal uses the language of the version of Excel you are using whereas Formula always uses American English.

Details of FormulaLocal are here and a useful page about internationalization in Excel is here

Upvotes: 3

Related Questions