Hi Jack,

Thanks for posting in the community!

From my understanding to this issue, when you run the VLookup function in
your VB project, the error code 2042 was raised in debug mode.

The definition of VLoopUp function is:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

This function is used to looks in the first column of an array and moves
across the row to return the value of a cell. The suggestion and analysis
from Ram and Tom is very helpful on this issue. There are two scenarios the
function will raise #N/A(2042) error.
1) If lookup_value is smaller than the smallest value in the first column
of table_array, VLOOKUP returns the #N/A error value.
2) If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP
returns the #N/A value.
You will obtain more information regarding this function from this link.
VLOOKUP
http://msdn.microsoft.com/library/en...html/sec6f.asp

As Tom has suggested, this error(2042) is defined as xlErrNA which is a
member of Excel.XlCVError. There are other excel defined errors in
XlCVError. This page will list them for you:
TempErr
http://msdn.microsoft.com/library/de...us/office97/ht
ml/sf886.asp

Please feel free to let me know if you have any further questions. I am
standing by to be of assistance.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.