Hi All,

I have a macro that will run automatically if a specific cell value changes but it only works if you type the new value in to the cell, not if you paste or paste special the new value. Anyone know a way around this?
I’ve tried creating a few auto run macros to test this and they all work when you enter the value into the cell by typing but not from a paste or paste special…

Thanks,

Craig...