Quote:
Originally Posted by soroush.kalantari
do you mean I should modify my code
|
No.
Quote:
Originally Posted by soroush.kalantari
or the way the inputs are addressed in the UDF?
|
for example:
Code:
=matchrow(Sheet1!A2,Sheet71!C3:E9)
or if in another workbook which is open:
Code:
=matchrow([AnotherBook.xlsx]Sheet1!$A$2,[AnotherBook.xlsx]Sheet1!$C$3:$E$7)
Use the mouse to select the ranges and the references will be correct automatically.