Find Duplicates

S

Shirley Munro

Hi

I want to find any duplicates in column B. However my problem is tha
I am trying to do this within a macro and when the macro is run th
number of cells being used in column B can vary each time. In the pas
I have had a fixed cell range, for example the cell range is fro
B2:B500 then I have been able to use conditional formatting with
formula: =COUNTIF($B$2:$B$500,B2)>1

Is there a way of doing something similar when I don't know the las
cell in the range.

Thanks

Shirley:
 
Top