I've been struggling with this for a while.

We get price lists from vendors in Excel format. I've designed a simple
program that uses .find to find products and display their description
and price in a simple form. The user simply keys in the product no.
into a text box and the product's details are displayed on the same
form.

Unfortunately I've had a lot of trouble due to formatting issues. .find
seems to be very picky about the source data's format and haven't found
a foolproof way to format the various lists.

Can anyone point me to a webpage or perhaps provide a brief description
of what I have to do to make our price lists compatible with .find?
Either programatically or by minipulating the source worksheets.

Thanks in advance.

Regards,

Robin