Vlookup property error?

[s4driver]

Does anyone know how to get this expression to work when the first digit is numeric (for the lookup value)? it works fine on everything that is a alpha char but stops at anything that looks like a number. The result is a Run-time error '1004' , Unable to get the VLookup property of the WorksheetFunction class

Found.Offset(, 0).Value = WorksheetFunction.VLookup(Left(Found.Offset(, 1), 2), Rng1, 2, True)

thanks in advance, s4

[:) Sixthsense :)]

Left is the Text function which converts Numeric data as Text so try like this...

Please Login or Register  to view this content.

[s4driver]

I'm still getting the same error message, It works fine until it comes to a value the contains a number as the first character in the cell, ie. 3M, 1S.

macro stop on same line yet.

Found.Offset(, 0).Value = WorksheetFunction.VLookup(vLkpValue, Rng1, 2, True)