Trigger an event when any cell in a column is changed

[scrabtree23]

What is the code to trigger a macro when any cell in column A of Sheet 1 is changed. My code fires the macro when the cell is entered. I only need it to fire when the cell is changed. Thanks.

[Fluff13]

You can use a change event, rather than a selection change

Please Login or Register  to view this content.

Although it doesn't work if the cells contain formulae.

[XLent]

if you mean, you want to isolate where the value changes (i.e. from A to B) then something like...

however, the more I think about it the less that would make sense... ;-)

Please Login or Register  to view this content.