Why not
=COUNTIF($B:$B,B2)1


"Shirley Munro"
wrote in message
news:Shirley.Munro.23bk2m_1140088201.1452@excelfor um-nospam.com...

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