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"
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"