View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Does anyone know how I can concat duplicate cells associatinginfo?

hi,

if you want to color the duplicate rows:

change:
Cells(i, 1).EntireRow.Delete

by:
Cells(i, 1).EntireRow.Color.Index = 3

isabelle

Le 2013-01-07 23:31, pai a écrit :

What if don't want to Delete the Duplicate Rows?