the code in the first answer helped me for a work I am doing but in case you get an error because it does not find the cell with the name you can use: row.Cells(0).Value to search by position.