Removing the square brackets didn't work. I had it like that before, but I thought I would try them.

Any ideas why your code won't work in my spreadsheet shg?

Any one else worked on something like this in the past? Is there an easier way to get 2 dynamic ranges into a drop down validation cell? I'm just sitting scratching my head now.