I'm trying to insert a formula in a cell but Appear an error when I set my own function. Anyone can explain me which it's the reason.
Thank
Sheets("market").Select
Range("M2").Select
ActiveCell.Formula ="=IF(DatoInformado(Bread!H9);0;1)"
Asked
Active
Viewed 14 times
0
Andres Perez
- 25
- 2
-
1Does `.FormulaLocal` instead of `.Formula` work? – BigBen Jun 01 '21 at 22:02
-
1When setting a range's `Formula` property from VBA you need to use the "US" comma separator. – Tim Williams Jun 01 '21 at 22:33