Rather than having 10 'if' statements I would like to compare the value of my variable to a list I can edit on a work sheet.
i have tried...
and
but neither work.
Any help would be appreciated.
Thanks
i have tried...
Code:
If varDirectory.Value <> Array(Sheets("PO Filter").Range("A2:A100").Value) Then
and
Code:
If varDirectory <> Array(Sheets("PO Filter").Range("A2:A100")) Then
but neither work.
Any help would be appreciated.
Thanks
Last edited: