Turn on the macro recorder, select the column, do Edit=find and find you
value. Turn off the macro recorder. Now use the recorded code to replace
you loop. Replace the hard coded serial number with a variable containing
the user's serial number.

Regards,
Tom Ogilvy


Dave wrote in message
...
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