Find Duplicates

  • Thread starter Thread starter Shirley Munro
  • Start date Start date
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Summing rows using formulas with variables 1
stop excel automatically changing formulas 3
% Difference between cells based on variable... 3
comparing 2 sheets with a range 2
expand duplicate check to multiple columns 3
Need Help With Macro to set a value in new sheets 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top