Put that in square brackets and you should have your vba code:Originally Posted by SamT
Sheets("Central Summary").range("C16").value=[CountIfs('Central Data'!A:A,COUNTIFS('Central Data'!M:M,A23),"On Hold")]
Put that in square brackets and you should have your vba code:
Sheets("Central Summary").range("C16").value=[CountIfs('Central Data'!A:A,COUNTIFS('Central Data'!M:M,A23),"On Hold")]
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote