Thread
:
vlookup, true false issue
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
vlookup, true false issue
To get THAT message , I think you are on a sheet where a1 is blank
try this
Sub vlookup_Don()
Set myrange = Workbooks("20060201.xls"). _
Worksheets("mysheet").Range("list")
Range("b1") = Application.vlookup([a1], myrange, 2, 0)
End Sub
--
Don Guillett
SalesAid Software
"pjjclark" wrote in
message ...
Below is what I've writtem so far:
Sub vlookup()
Dim myrange As Range
Set myrange =
Workbooks("first.xls").Worksheets("sheet1").Range( "list")
fred = Application.WorksheetFunction.vlookup(Range("a1"), myrange, 2,
True)
Range("b1") = fred
End Sub
The contents of "first.xls" has numbers 1 to 10 in column A and letters
a to i in column B.
My issue is if I change the 'true' value to 'false' within the vlookup
function. It works fine until I enter a value that is not in my list, I
get a 'error 1004 unable to get the vlookup property of the
worksheetfunction class' message box come up. I am expecting a '#N/A'
instead.
I'm using excel 2003 with
vb
6.3.
Any ideas?
--
pjjclark
------------------------------------------------------------------------
pjjclark's Profile:
http://www.excelforum.com/member.php...o&userid=29180
View this thread:
http://www.excelforum.com/showthread...hreadid=508959
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett