Alerts when value change in cell from a formula

[hudson andrew]

Hi All,

I was hoping small help on the code i have.

My current code fires only when there is change in the (Manually) in column D .and that is refereed to my range in Column B. but i did not realise my column D will be pivot table numbers in my orginal workbook where i am building the code. is there a way i can change the code or help me so that macro triggers with calculations from Column D asuming column D is my pivot table numers . and code to trigger only when there is change in pivot tables refererd as formula cells in column B.

below is the code i have so far .

Please Login or Register  to view this content.

[Mumps1]

Look into the Worksheet_Calculate event.

[hudson andrew]

Hi Thanks for your time .. ya i did tried it but no use .. it is throwing error ..