macro to call when any value changes in a range of cells

[tanvi_kalra]

I have one macro to call when any value changes in a range of cells then worksheet cvhange event fires and call this macro. This macro is used to copy pivot data from one sheet to the active sheet but this is not pasting the data. here is the code . please help to process this.

Please Login or Register  to view this content.

[patel45]

can you attach a sample file ?