clara wrote:
Hi al,

I have a named range called List (A1:A10) and I want to retrieve the second
item(A2) so the code is : worksheetfunction.index( "List", 2, 1), but I got
"Unable to get the index property of worksheetfunction class".

Clara

You will have to use a syntax like this:

WorksheetFunction.Index(ThisWorkbook.Names("List") .RefersToRange, 2, 1)

HTH, CoRrRan