I can't seem to get the syntax right on the worksheet functions. Any help?


WorksheetFunction.Sum(ActiveSheet.Range("B:B")) <> worksheetfunction.COUNTA('Pasted Zip Codes'!C[2]) then