actually, that works...gettting the value in res.

my problem is that I need to refer to another file.

if you look at the formula it specifies a particular workbook
(sheet1)

res = application.match("some name", worksheets("*sheet1
").range("a1:a450"),0)


I also need to specify from what file it's in (since I have more tha
one file open at once)

I tried [fileName.xls]Sheet1 but that didn't work when I tried it...

not sure on what the syntax would have to be..

--
Message posted from http://www.ExcelForum.com