ExcelPupper
Board Regular
- Joined
- Mar 2, 2020
- Messages
- 112
- Office Version
- 2019
- Platform
- Windows
I am trying to put IF & CountIF on the same formula on the code below but I get syntax error. What could be the problem?
VBA Code:
Sub CntNoEntry ()
Dim lr as long
Sheets(6).Range("A1").Formula = "=IF((COUNTIF("G8:G" & lr,"*No Entry*"))>0,"Provide Data","")"
End Sub
Last edited: