PDA

View Full Version : VBA CODE showing result as #VALUE!



Pravina
10-11-2017, 04:50 AM
Hi ,

I have created below vba code. its running but showing result as value error. Please correct it.

Sub stdsuppliername()

Range("au13") = [VLOOKUP(sheets("Paste FER").RANGE("G87")&"*"&sheets("Paste FER").RANGE("S87"),CHOOSE({1,2},Sheets("Lookup Table").range("AQ1:AQ233")&sheets("Lookup Table").range("AR1:AR233"),sheets("Lookup Table").range("AS1:AS233")),2,0)]
End Sub

mancubus
10-11-2017, 12:31 PM
check this out:
http://analystcave.com/excel-vba-evaluate-tips-and-tricks-to-use-application-evaluate/

Fabian76
10-15-2017, 09:28 PM
try thi sout