ExcelMonkey wrote:
Can't seem to get this to work. Run-time Error 438 - Object does not support
property or method. Why is this? RowNumberArray has numbers in it.

NumOccurences = Application.WorkshseetFunction.CountIf(RowNumberAr ray,
RowNumberArray(X))

The worksheet function COUNTIF doesn't accept arrays. If you don't want
to loop as suggested, if the functions in the freely downloadable file
at http://home.pacbell.net/beban are available to your workbook

NumOccurrences = ArrayCountIf(RowNumberArray, RowNumberArray(X))

Alan Beban