how to exclude a criteria using auto filter

In my spreadsheet the column "C" can contains all values of 0,1,2,........10.

What exactly i need is, if the column "C" contains any value other than 0, in need a msg box that "values greater the 0 found"

i tried using below code
if activesheet.range("C:C").autofilter:=3,criteria:=">0",then
msgbox"values greater the 0 found"


But i find this not working.Can someone help on the above

If you use autofilter (>3), all you'll see is the rows with >3 in Column C.
You should not need a message box as all of them will be >3.
I assume that that is what you have in mind as you mentioned autofilter.
Adjust the code below.

Please Login or Register  to view this content.

try this?
it firstly checks if there is anything in C:C, then uses a worksheet function to count values that are greater than 0

Please Login or Register  to view this content.

if you change it to this, it will count values that are not equal to 0 (either greater or smaller)

Please Login or Register  to view this content.