Vlookup VBA error if string

[alejorubi]

Hi all,

I have the attached program that when I select a number from column A then it vlooksup for values but if I change numbers for words in column A then it gives me an error. Could you help me out please

[mehidy1437]

It may be because of this. Please check.

Attachment 649908

[Greg M]

Hi there,

The error you describe occurs because the highlighted function in the following statement:

Please Login or Register  to view this content.

is attempting to convert a string value to a numeric value.


See if the following version of your code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[mehidy1437]

Nice Solution