If Cells(Iloop, "A") & Cells(Iloop, "B") & Cells(Iloop, "D") &
Cells(Iloop, "E") & Cells(Iloop, "F") & Cells(Iloop, "G") _
= Cells(Iloop - 1, "A") & Cells(Iloop - 1, "B") & Cells(Iloop - 1,
"D")
& Cells(Iloop - 1, "E") & Cells(Iloop - 1, "F") & Cells(Iloop - 1, "G")
Then
Cells(Iloop - 1, "C") = Cells(Iloop - 1, "C") & ", " & Cells(Iloop,
"C")

should be

If Cells(Iloop, "A") = Cells(Iloop - 1, "A") & Cells(Iloop, "B") =
Cells(Iloop - 1, "B") etc. etc.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=398779