Hello. I am trying to use the countif function in vba on memory only arrays. For example:
Sub mem_countif() Dim a(), b, c a = Array(1, 2, 3, 4, 5) b = Application.Count(a) c = Application.CountIf(a, ">3") End Sub
should give b = 5 and c = 2. Currently b = 5 but c = an array with 5 x 2015 errors.