Hi

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

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

Thanks

Shirley:)


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=513126