VBA Error 13 Mismatch Error on Vlookup

3333.PNG

222.PNG
Hi guys I keep on getting the error 13 Mismatch.

Everything is fine but after I click the Process button the error was shown. any help on eliminating the error 13?

Here's The code. Thanks

Please Login or Register  to view this content.

Try replace that line by this line:

Please Login or Register  to view this content.

Hi,

You need some defensive programming. Try code like the following:

Please Login or Register  to view this content.

Comments:
a. The use of 'Integer' is archaic (but not wrong) and should probably be replaced by 'long' which stands for 'long integer'. The internal representation in Excel is of type 'long' anyway.
b. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). https://www.excel-easy.com/vba/examp...-explicit.html

Lewis

Thanks guys all of this works I will close this thread now.!