Suppose you have a table that looks like this:

Fruit Apples Oranges etc

John (numbers)

Bill

Sue

etc



and you insert > name > create the names in the top row & L column,
then in a formula you can say things like

= John Apples

or

= Apples + Oranges

Meaning the values in that row. Please is there any way to do the equivalent
in VBA? If (in VBA) you have option explicit and you say

x = John( 2)

you get an undefined variable error.

Sorry if this is a FAQ. I searched. Only thing I could find that looks relevant
was is 2006 . Somebody said " use the INDEX function" but I didnt
say how to do this. INDEX requires numerical arguments, so it cannot use
the defined names .

Thank you.