Performing Countif function within VBA

[jeffreybrown]

Can't seem to get this syntax right.

Establishing a unique list of column A in column K whick works fine, but then starting in L2 need a countif formula. I got it to work with the .FormulaR1C1 format, but how can this work with .Formula?

Please Login or Register  to view this content.

[DonkeyOte]

perhaps

Please Login or Register  to view this content.

[Bob Phillips]

Perhaps

Please Login or Register  to view this content.

[shg]

Something like

Please Login or Register  to view this content.

[jeffreybrown]

I am getting a run time error 1004 Method Range of Object Global Failed.

This is the highligted line.

Please Login or Register  to view this content.

The formula starting in L2 should be =COUNTIF($A$2:$A$13,K2)

Run the cursor over Set rng and it says rng = nothing

[shg]

Please Login or Register  to view this content.

[jeffreybrown]

Thank you everybody. Works great...