使用变量时，通过excel中的VBA设置验证失败

I am trying to set the data validation for a range of cells using VBA. I get a run-time error 1004 (so helpful) "Application defined or object defined error" with this code.I am trying to set the data validation for a ra