How to detiremine the target row
Thanks Frank,
I'll give it a shot.
-Minitman
On Thu, 15 Apr 2004 09:31:12 +0200, "Frank Kabel"
wrote:
Hi
try
row_number= application.worksheetfunction. _
match(worksheets("Enter").Range("AP2"), _
worksheets("INV").range("A1:A1752"),0)
--
Regards
Frank Kabel
Frankfurt, Germany
Minitman wrote:
Hey Frank,
I thought of that and changed their names back to the actual cells
they represented. SI_InvNo went back to being Enter!AP2 and
INVOICE1
went back to being INV!A1:A1752. Did not help. I am still getting :
Run-time error '1004':
Method 'Range' of object '_Worksheet' failed
I keep going over the help files and they don't touch on this
problem.
I am open to suggestions
TIA
-Minitman
On Thu, 15 Apr 2004 07:59:53 +0200, "Frank Kabel"
wrote:
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
|