Making lengthy AND statements succinct

Hi all, working the weekend... again.

If anyone has any suggestions for shortening a lengthy AND statement down to something more pretty I will love you all forever as always

Please Login or Register  to view this content.

This code isolates route numbers and only lets the ones defined in a range of cells that is then copied into the Route array variable. It works its just a little ugly.

You can use match worksheet function

Please Login or Register  to view this content.