Forum Discussion
Solved
Adding COUNTIF formula to cell by VBA code
Morning all, need some assistance. Attempting to insert a new formula by VBA with an already working Macro. All the other references unhighlighted below work perfectly, but I am missing something w...
Quotes inside a quoted string must be doubled:
.Range("AH11").Formula = "=COUNTIF($B11:$AF11, ""B"")"
As always, thanks Hans. Swear i tried that, but likely tried '"B"' instead, and regardless didn't come to the right solution.