Hello,

I am using an match fomula to get a row: Match(nr1&nr2, nr1list&nr2list, 0) -- this works perfectly in excel.

But once i try this same in an excel vba functions i get an error and do not know how to fix it.

dim nr1, nr2 as string
dim nr1list, nr2list as range

nr_row = Worksheet.Function.Match(nr1 & nr2 , nr1list & nr2list , 0)

I was thinking of using a match or find to get the row, because my list can go up to 1000 rows and i need the function in every row. and was thinking if i use a "for each" that will just slow down the file.

Does anyone have a idea ?

Thank you.