REPEATED VALUES!

[jay dean]

In range("A1:AZ4000").cells are data. This macro should check to ensure
that EACH figure in the above range appears ONLY ONCE.
If there are more than one of ANY value, then it should color the cells
containing the additional (redundant or repeated) values red.

Any help would be appreciated.
Thanks
Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***

 

[paul.robinson]

Hi
Have a look at some of Debra Dalgeish's stuff using formulas in
conditional formatting

http://www.contextures.com/xlCondFormat03.html#Duplicate

regards
Paul

 

[jay dean]

I appreciate the info., but I will need a macro. This is to process a
lot a data in several varying ranges in which fixed formulas will not be
very useful.

Any help would be appreciated!

Thanks
Jay

*** Sent via Developersdex http://www.developersdex.com ***