Reference Cell in Named Range

M

mark1

How do I reference a single cell in a named range? I
looked for this in the help files and couldn't find
specifically what I was looking for? B1 through B6 is a
list of numbers named "Numbers". How do I reference the
second number in the column using the name?

Column B, Range named "Numbers"
10
20
30
40
50
60

Want to be able to reference the second number by saying
something like =Numbers2 to reference the second cell in
the named range.

Would the format be the same if I wanted to reference that
cell in a VBA macro? Would the format be the same for a
cell in a labeled range?

Thanks again for the help!
 
A

Alan Beban

mark1 said:
How do I reference a single cell in a named range? I
looked for this in the help files and couldn't find
specifically what I was looking for? B1 through B6 is a
list of numbers named "Numbers". How do I reference the
second number in the column using the name?

Column B, Range named "Numbers"
10
20
30
40
50
60

Want to be able to reference the second number by saying
something like =Numbers2 to reference the second cell in
the named range.

Would the format be the same if I wanted to reference that
cell in a VBA macro? Would the format be the same for a
cell in a labeled range?

Thanks again for the help!
Click to expand...
=INDEX(Numbers,2) will return the value of the second entry in the range
named "Numbers".

Alan Beban
 
Top