Is this really an array or just a range on a worksheet?

If it's a range, you could use something like:

msgbox application.counta(activesheet.range("a1:b10"))

This will return the number of non-empty cells.

Confused_in_Houston wrote:

I would like to know how to write an argument that will count the number of
items in a group or an array.

Example

A1 DATA1
A2 DATA2
A3 DATA3
A4 DATA4
A5 4
A6 DATA1
A7 DATA2
A8 2
A9 DATA1
A10 DATA2
A11 DATA3
A12 3

Thanks

--

Dave Peterson