error message: argument not optional for CountIf function

Hi,


I am trying to write a macro that places the values of yellow cells (with unique values in the row) in another worksheet. I am using a Countif function. I am getting "compile error: argument not optional " for

Please Login or Register  to view this content.

I alreadt tried to put "periode" between brackets but i get then the error message as well.

Please Login or Register  to view this content.

What am i doing wrong?
Any input is much appreciated!

You only supplied a range to the CountIf function but nothing to search for. What I marked in red is the range for CountIf to search in... something (what to be searched for) needs to go where I put the blue question marks.

AmountLastPeriod = WorksheetFunction.CountIf(Range("H:H", Periode),???)

try

Please Login or Register  to view this content.