Thread: compare rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Papa Jonah Papa Jonah is offline
external usenet poster
 
Posts: 148
Default compare rows

Is there a macro that can be used to compare a row to the row above resulting
in a highlight if it is a duplicate?
What I need is to identify rows that are cell for cell duplicates - meaning
that if EVERY cell in the row is identical to the one above.

TIA
Papa