Hi Drew I seem to be having some issues in excel and I noticed you outlined some similar to my current problems. I am trying to create a search and return rows in excel vba. I have the searching part working (which I have to admit I did not create and I patched up with bits here and there). I need to be able to return the entire row(s) which the search function finds. As things stand I have currently got the search working, and returning the criteria in a new worksheet with the reference of each cell that has been found as a link. Would you be able to help me return the full row? Thanks for your time Abda