Hi,
Please can someone help me?
I would like code that once 1 cell has been entered in a range, the rest of the range enters a "C".
So basically my range is D5:D15
If the operator enters a "N" then nothing happens.
If the operator enters a "Y" then the rest of the cells in the range auto fills with a "C", but if the "Y" is deleted then all the "C" are deleted as well.
I hope this makes sense.
Thanks
Dan
Please can someone help me?
I would like code that once 1 cell has been entered in a range, the rest of the range enters a "C".
So basically my range is D5:D15
If the operator enters a "N" then nothing happens.
If the operator enters a "Y" then the rest of the cells in the range auto fills with a "C", but if the "Y" is deleted then all the "C" are deleted as well.
I hope this makes sense.
Thanks
Dan