Search excel file, return value from different column

[ben64]

You are not closing the sheets, workbook and workbooks references. Before closing the _Application reference you can use the Quit method to exit Excel. Also, as I said in a previous post the reference should be closed in the reverse order they were opened (i.e. _Application reference: first open, last close)(worksheet should be closed before _Application).

Ben64

[buickgn]

ben64,

Thank you so much for your help and sticking with me. It works perfectly now. Take care!