View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zen Zen is offline
external usenet poster
 
Posts: 16
Default Macro - highlight rows

Hi everybody,

I have a chunk of records stored in excel and are tracked by account number.
Some of the account numbers are duplicated and I wish to run a macro which
can loop through the records and highlight the row s which have duplicated
account numbers. How do i do it? Thanks in advance