View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default 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