So I have two excel versions one at home and one at work. Both are excel 2016 but the one at work is blocked for updates.
The bug I'm getting is on the most up-to-date version at home. Excel at work doesn't seem to have this bug.
And here's the code:
.Add Type:=xlValidateList...