Case Sensitive removal of duplicates in VBA

[awsumchillicrab]

Hi all,

In removing duplicates with case-sensitivity, I can't use a COUNTIF so the substitute for counting is this formula entered with Ctrl-Shift-Enter:

=SUMPRODUCT(--EXACT($D$13:$D$16,D15))

Now I want to incorporate this into VBA, so that I can include the .delete method. How do I do it?

For starters, VBA doesn't seem to have WorksheetFunction.Exact

 

[Weaver]

If you were really desparate to use that function, you'd have to use vba to write the formula to a free column, filter it for results above 1, delete the visible rows then delete the temporary formulas.

 

[Peter_SSs]

If you are still looking for help, can you tell us just what you have in your sheet, where it is and what you are trying to achieve?

What version of Excel are you using?

 

[awsumchillicrab]

Excel 2007.

I was just treating it as an academic exercise, when I realized that COUNTIF doesn't do case sensitivity.

Thanks for the solution Weaver.