VBA CountIF syntax error.

[jcihak]

Hello,


I am trying to fill a cell in with a COUNTIF formula, but it appears to not be formatted correctly. I am sure I have all the necessary quotations. What is keeping this from working? It is saying that there is an unexpected error at the end of the formula with the ")"


Range("E4").Select
ActiveCell.Formula = "=COUNTIF('Prepared Screens'!Q:Q,">14")"
Range("E5").Select
ActiveCell.Formula = "=COUNTIF('Senior Reviewed'!Q:Q,">14")"
Range("E6").Select
ActiveCell.Formula = "=COUNTIF('Manager Reviewed'!Q:Q,">14")"

 

[Fluff]

All quotes inside the formula need to be doubled up like

"=COUNTIF('Prepared Screens'!Q:Q,"">14"")"