View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default REPEATED VALUES!

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 ***