Hi guys,

I'm new to VBA but slowly learning, I'm not sure if what I am trying to do is possible in the way I'm trying to do it. Any help/guidance would be much appreciated.

I am trying to set the value of a range of cells to be the count of a range of cells in another range. To try and keep it simple I am using this code:

Range("J1:J5").Value = WorksheetFunction.CountIf(Range("A1:A20"), Range("I1:I5"))

I get a mismatch error, as I said any help would be great.

Thanks in advance.