Hi, dtvonly,

you may use CountIf to check the number for each item, CountA if only values are in that range, get the last cell via

MsgBox Range("A" & rows.count).End(xlUp).Row - 1
if you have the header in row 1.

The command you tried to use assumes that there would be a range being named like that which my Excel doesn´t allow.

Ciao,
Holger