I have a formula
Sheet1.Range("P7").FormulaArray = "=IF(AND(COUNTIF(A$1:A8,A8)=COUNTIF(A:A,A8),COUNTIF(A:A,A8)>=1),"Completed","")"
I am getting a syntax error in VBA using this not sure why. How are array formulas supposed to be written?
Asked
Active
Viewed 15 times
0
West
- 1,882
- 2
- 17
- 51
-
1You need to double up the quotes within the formula, see the linked duplicate. – BigBen Jul 14 '20 at 01:07
-
@BigBen Great cheers! – West Jul 14 '20 at 01:11