Hi,
Can someone show me a better way to do the following:

I have a form with a "Find" button on. When the user presses Find they are
asked to input a serial number. Then the macro looks down the serial number
column in the spreadsheet, finds the number then returns all the data on the
row back to the form.
I use a for i = 1 to 1000 and just keep looping through untill the serial
number is found. The spreadsheet is really big now and is becomming slow to
run.

please help

Dave




Please remove "no.thanks."
and add "blue" in front of yonder to email me.
Sorry for inconvenience but feed up of spam mail