I use this kind of code:

Dim LC_Chars as range
....
set lc_Chars = worksheets("SomeSheetname").range("LC_Chars")

....

Then I can use the =vlookup() formula that you originally posted.




Bert wrote:

Dave:
Thanks for your suggestions. The value of the variable X will always be a
text value because I'm taking it from a text string. As it turned out, I'd
named the range on the spreadsheet, and Chip caught that, so it's working
okay now.

"Dave Peterson" wrote in message
...
Is the value in the cell with the 7 in it a real number or text?

Use
=isnumber(a1)
(change a1 to the correct cell address)

I'm not sure where you're getting X, but maybe you want to coerce it to
number
before the =vlookup():
sz = Application.VLookup(clng(x), LC_Chars, 2, False)
or
sz = Application.VLookup(cdbl(x), LC_Chars, 2, False)



Bert wrote:

I have a named range ("LC_Chars"), and am trying to use the following
code:
sz = Application.VLookup(x, LC_Chars, 2, False)
It is comparing a single character (x; in this case x="7", though the
error
is generated no matter what the value of x.). The named range contains
two
columns. The search column has been formatted as text and does contain
a
"7".
The fix has to be simple, but I'm not seeing it.
Bert

--

Dave Peterson

--

Dave Peterson