Hi
make sure that both names really exist. Sound like either SI_InvNo or
INVOICE1 is not defined

--
Regards
Frank Kabel
Frankfurt, Germany


Minitman wrote:
Hey Frank,

I can't get the code to work!

I keep getting

Run-time error '1004':
Method 'Range' of object '_Worksheet' failed

Debug highlighted this whole row:
row_number= application.worksheetfunction. _
match(Range("SI_InvNo"),range("Invoice1"),0)

Any idea as to what is going on?

TIA

-Minitman



On Wed, 14 Apr 2004 14:30:54 -0500, Minitman

wrote:

Thanks Frank.

That is what I was looking for. I had a bit of trouble getting
Excel
help to come up with anything on "match", until I tried "MATCH" then
it came up.

-Minitman

On Wed, 14 Apr 2004 21:01:30 +0200, "Frank Kabel"
wrote:

Hi
do you want a VBA solution or a worksheet function. For the first
one add the line in your code. So use something like

sub foo()
Dim row_number 'this is a variable
row_number= application.worksheetfunction. _
match(Range("SI_InvNo"),range("Invoice1"),0)
msgbox row_number
end sub

the '0' idnicates that Match shoud look for an exact match (see the
Excel help for more about the MATCH function syntax)