Hi
you could use the worksheet function MATCH in your VBA code. something
like
row_number=application.worksheetfunction.match(inv oice_number,range("In
voice1"),0)

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
Greetings,

I have this worksheet that I use to enter invoice information. I am
using it to double check the entered invoices and modify any that are
incorrect. I don't know how to replace the incorrect record with the
corrected one. I can get the info pasted down once I can determine
which row it came from. I just don't know how to find the row with
the same invoice number (invoice number to be pasted is in named
range
SI_InvNo. This needs to be found in named range Invoice1)

Anybody have an idea?

TIA

-Minitman