software

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)gt;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: www.excelforum.com/member.php...nfoamp;userid=836
View this thread: www.excelforum.com/showthread...hreadid=513126Why not
=COUNTIF($B:$B,B2)gt;1quot;Shirley Munroquot; gt;
wrote in message
news:Shirley.Munro.23bk2m_1140088201.1452@excelfor um-nospam.com...
gt;
gt; Hi
gt;
gt; I want to find any duplicates in column B. However my problem is that
gt; I am trying to do this within a macro and when the macro is run the
gt; number of cells being used in column B can vary each time. In the past
gt; I have had a fixed cell range, for example the cell range is from
gt; B2:B500 then I have been able to use conditional formatting with a
gt; formula: =COUNTIF($B$2:$B$500,B2)gt;1
gt;
gt; Is there a way of doing something similar when I don't know the last
gt; cell in the range.
gt;
gt; Thanks
gt;
gt; Shirley
gt;
gt;
gt; --
gt; Shirley Munro
gt; ------------------------------------------------------------------------
gt; Shirley Munro's Profile:
gt; www.excelforum.com/member.php...nfoamp;userid=836
gt; View this thread: www.excelforum.com/showthread...hreadid=513126
gt;