Runtime Error 91 when using Worksheet().Range().Find().Select

[michaljireht]

Good day!

I am currently having a runtime error when I execute this code:

Please Login or Register  to view this content.

In H2 I have a dropdown list of all values in DATA Sheet A2:A6001 and in column Y i was hoping to input "Reserved" if the value in A:A matches the value in H2.

Any help is appreciated.

Thank you!

[romperstomper]

The error means that the lookup value wasn't found. Find can be tricky as it has a lot of optional arguments that persist between find operations, whether done in code or manually. I'd use MATCH here:

Please Login or Register  to view this content.

The fact that your code wasn't finding a match even though you are using a list of used values, may also mean that you have a data type conflict - for example, your variable is a string, but if the values are numeric that could cause a mismatch.

[:) Sixthsense :)]

Please Login or Register  to view this content.

[michaljireht]

I used the first code. It worked perfectly!

Thank you so much!