I would like the code to execute if the value of any cell changes, but I do
not want to copy the code to more than one location. I.E only one place to
update the code if maintenance is needed.

Regards
George

1) from the subject line: code that changes a cell's value ouight to be
written in a standard module. It could really go into other places, but "good
practice" would be a standard code module

2) the cell changed event can be trapped in a worksheet's code pade- this
fires when a cell's value is changed by entering a new value, NOT when a
value changes as a result of a calculation. The quick way to get to a sheet's
code page is to rioght click the tab and select the last item of th epop-up
menu.



"George Furnell" wrote:

I would like the code to execute if the value of any cell changes, but I do
not want to copy the code to more than one location. I.E only one place to
update the code if maintenance is needed.

Regards
George