Hi,

I am trying to write a script that will run when a particular cell changes and I have got it all to work except the last little bit. I want the script to select a value from a cell with data validation i.e if range("countryversion") = "version 1.0", then range ("selected_country_version") which is a data validation cell will select "version 1.0" from the list of data it has to validate.

Is there anyway to do this? I have setting the range.value but this just produces an application/object-defined error.

Any help would be great

Thanks