Can the code above be used in the worksheet change event so that an
cell's value can be changed within a certain range.

I have tried but an error message comes up saying wit
me.range("A:A").... is not valid.

Thanks
Rac

--
Message posted from http://www.ExcelForum.com