Checking Against Excel List via QM

[philipq]

Did that...

So here is my code so far:
How do I check one list within the other:

Macro NC VCC Release Corrections

Code:

Copy      Help

;Obtain 2 lists into arrays
es.Activate(1 "Data") ;;Activate Sheet
es.SelectRange("M:M" 1) ;;obtain used range
es.CellsToArray(SANamesMaster "sel") ;;Obtain Master list of Sales Advisor Names from 'Data' Sheet

es.Activate(1 "VCC Release Spool") ;;Activate Sheet
es.SelectRange("G:G" 1) ;;obtain used range
es.CellsToArray(SANamesCheck "sel") ;;Obtain 'To Be Checked' list of Sales Advisor Names from 'VCC Release Spool' Sheet

;;Check one array against another and change those not in Master list
for r 1 SANamesCheck.len ;;for each row
,if SANamesCheck[0 r].len
,,if SANamesCheck[0 r] ;;*******How to check if SANamesCheck is in SANamesMaster?********
,,,out r