How to use worksheet function Index

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
clara said:
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
Click to expand...

You will have to use a syntax like this:

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

HTH, CoRrRan
 
Hi
Use
worksheetfunction.index(
  • , 2, 1)

    The square brackets returns the "value" of the name "List" i.e. the
    range.

    regards
    Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
Unable to get the VLookup property - worksheet.function error 2
INDEX return multiple columns 1
index function in vba 3
Acos function 3
VLookUp Function 3
VBA equivalent for Excel "indirect()" function in UDF 8
WorkSheet Function 5

Back
Top