green99
11-07-2017, 01:44 AM
Is there any way that I can get #N/A using vlookup code in VBA if the corresponding value is not available?
It just gives errors when the value is not found.
On using On Error Resume Next , the error is resolved however, still after trying many ways I am unable to print #N/A.
Kindly help
It just gives errors when the value is not found.
On using On Error Resume Next , the error is resolved however, still after trying many ways I am unable to print #N/A.
Kindly help