finding a specific string in Excel column B

[philopian]

Does anyone know the code or can send me in the direction to it... to solve this problem...

Using VB.NET i want find a specific string that occurs in column B of an Excelsheet and copy that entire row and paste it in a new worksheet. This string occurs a couple of times in this B column.

I know how to open up an excel sheet in VB but I'm having difficulties searching for the string and then copying that entire row and do it multiple times (loop until the end of the column)

thanks