I want to compute a range name, JLE, say, from VBA code, which
is returned in cell A1 and then to use the contents of A1
as the second argument in VLOOKUP. The output type of my function
would appear to need to be of type "Range". When it is
string type, it does not work. This must be really elementary -
I am just getting into VBA, but it is frustrating. Ideas?

In more detail, In A2, if I manually enter =VLOOKUP(41,JLE,2)
it works. I want instead =VLOOKUP(41,+a1,2)
to work. The problem is that the contents of a1 are recognized
as character, not as a range name. I need to somehow convert +a1
to a range object. Ideas?

Gary

Hi Gary
If you mean how to use VBA code to lookup values,
use this syntax:

answer=WorksheetFunction.VLookup(41, Range(Range("A1")), 2)

-vemaju