I have data validation (allows values in a list) set in column A (except for
A1:A5). I want to change the validation list dynamically because the values
i'm interested in will change as a query is refreshed. I've tried creating a
string variable that captures the range (set myRange = Range(("AB2"),
Selection.End(xlDown))) and using that to modify the validation:

Range("A:A").Validation.Modify xlValidateList, xlValidAlertStop, , crsRange

but i get this error - "Application-defined or object-defined error".

I get the same error if i try to create myRange as a string variable, too.
The range i want to use for the validation list will change each time a
person uses the file, so i need to get this to work.

Any advice?

Thanks