when lookup value does not found then exit sub

[zico8]

Please Login or Register  to view this content.

how to display msgbox and exit sub if lookup_value (cells(1,1)) does not exist in my data_description.Range
?

[Bernie Deitrick]

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

You could replace the Vlookup with this...

name = data_descriptions.Cells(name, 5).Value

[zico8]

Hi,

In all your samples I have run-time error '424' in line:

Please Login or Register  to view this content.

[Norie]

What is data_descriptions.Range supposed to refer to?

If you drop .Range from that does the code work?

[Bernie Deitrick]

It may be a problem with data_descriptions

Here was the code that I used to test

Please Login or Register  to view this content.