Searching Excel with VB

[Lddowser]

Hi

Was wondering if one of you guys/girls with better knowladge of using visual basic in Excel would be able to help me.

What i would like to do is be able to search an excell workbook for an account number then copy all the information in that Row and place it into another workbook.

I presume i would need to use an input box?with a Vlookup? would that be able to search a workbook?. The number that i would be looking for would be in the first colume on everysheet of the workbook. Its basically like the find function. just trying to make the whole process as automated as possible

My Visual basic is limited and i have not programmed for a few years.

Thanks in advance

[zaza]

There is a find function.

set mycell = Range("A1:A65000").find("cobblers")
 if not (mycell is nothing) then
   msgbox "The row you are looking for is " & mycell.row
 end if

HTH

zaza

[Lddowser]

Thanks for the response...

that code looks great.. im i right in saying that it will tell me the row number of the number i typed in??

Im looking for something that will copy the whole row for the number i type in and put it on a different workbook.. if that makes any sense?

[si_the_geek]

You should be able to replace the msgbox line with something like this:

ThisWorkBook.Rows(mycell.row).Copy Workbooks("name of other workbook").Rows(1)

Where 1 is the row of the other workbook to paste into.