CountIf syntax in VBA

[Armitage2k]

Hi,

having some troubles with Countif in VBA over here.
I am checking a range for duplicate entries from the bottom to the top and want to delete the first duplicate entry entire row. I changed the checking range from the whole column to all cells from G16 until the last entry of column G, but i receive a 1004 invalid number of arguments error. Did I miss something here? I am not really familiar with the countif syntax in vba.

Please Login or Register  to view this content.

thanks a lot!
A2k

[Andrew-R]

You're trying to use a range of values for your condition, try using:

Please Login or Register  to view this content.

[Armitage2k]

works great now, thank you very much!
A2k