Quote Originally Posted by xld
[vba]

Cells(i, 1).Value = Cells(1, 2).Text & ","

'...

Cells(i, 1).Value = Cells(1, 3).Text & ","

'...

'etc[/vba]
Where would i put it? If i put in the Else statement. The next IF statement for the value will overwrite that current cell, wouldnt it?