excel vba data validation

[Kaps_mr2]

Hello,

I am trying to set up data validation using VBA. I have created my ranges:-

and these are well defined (i.e when I go to Name Manager in excel I can see them.). However when I set up the data validation as per below, I get an "#N/A"

 

[Kaps_mr2]

solved.