"Find" produces that error when what you are searching for is not foun
on the spreadsheet. Are those values that are giving you the error o
your sheet? As Doug pointed out you may have to format your query, bu
also make sure what's on your spreadsheet is formatted properly so tha
it will match with your query

--
Message posted from http://www.ExcelForum.com