Excel 2007 - Why is VLookup in VBA failing with runtime error 1004.
Jun 15, 2012. You are asking vLookup to return on a 2 column range, against a 1 column range. Change BRange = "A2B9" to make your vLookup pick up. Feb 28, 2016. VLookupUserName. VBA is by default case sensitive so while the user name lookup is not case-sensitive, the password check is case. Aug 5, 2013. There is a way to skip the errors inside the code and go on with the loop. VLookupcurrName, rngLook, 13, 0 If Err. Number 0 Then ''error.
Excel - Error 1004 - Vlookup in vba - Unable to get the Vlookup.
Aug 28, 2015. You need to Dim dataRef as Range and then Set it. See code Below Dim DataRef as Range Set dataRef = Worksheets"Shipping Data". Aug 27, 2013. That can mean any number of things. It may simply mean your Datai, 4 value is not found in LookupRange. Run-time error '1004' Unable to.