Find String in an Excel list using VBA

[ions]

Dear Excel Expert,

I have a dynamic list in Excel that will contain strings representing codes.

i.e

MEM
YYZO
KAC
PAPKG
QEP
LMNT


The user can add or delete from the list but the list will remain contiguous.


In my vba code I currently have the below line which has the codes hard coded.

If Not (varElement.Broker = "MEM" Or varElement.Broker = "YYZO" Or varElement.Broker = "KAC" Or varElement.Broker = "PAPKG") Then

How do I convert the hard coded NOT (A OR B OR C ...) to use the dynamic list instead?

Thank you

[kvsrinivasamurthy]

Assumed your data Range is From A11 cell.

Add this code insted of

Please Login or Register  to view this content.

Code to be added

Please Login or Register  to view this content.

[ions]

Thank you very much for the code.

I renamed the variables. Also my list starts at H where H1 is the List Label.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Pl mark the thread SOLVED.