Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup, true false issue
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Reverse false and combine with true true value | Excel Worksheet Functions | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |