thanks for the explanation. i really don't need to change anything, as long
as it works, i was just curious why i didn't need the for/next statements.

--


Gary


"humejap" wrote in
message ...

The statement

Cells.Replace

will affect all rows as 'Cells' without any parameters refers to all
cells on the worksheet.

If you want to limit the rows for the replace you could try

Range( Cells(1,1), Cells( LastRow, 1 ) ).EntireRow.Replace

The parameters of the Cell statement above relate to Row and Column.

Hope that helps.


--
humejap
------------------------------------------------------------------------
humejap's Profile:
http://www.excelforum.com/member.php...fo&userid=5506
View this thread: http://www.excelforum.com/showthread...hreadid=399368