Look in the vba help index for FINDNEXT.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Johnny" wrote in message
...
anyone know how create like look at all columns and fnd text then combin
that
row and put it in different column.
like this is what I need, but this only can do it in the same row:
=IF(D125="FISH",A1&","&B1&","&C1&","&D1&","&E1,"")

exsample: there are many rows that has (fish), I want to look at all
columns
and find the rows has(fish), combin that row, and by order put it at
column
M1,M2,M3....