For a worksheet change event to happen, the change has to be physically (manually) changed. A change as a result of a formula will not affect a worksheet change event. You may want to change the event to be triggered off some thing else (ie. Command Button?)