Something missing in my code to run macro when 2 cells change

[bazofio]

I guys

I have this code that should run a advanced filter when the data in M4 and N4 changes, this is in sheet1. In M4 i have a formula to calculate a result and in N4 is a link from other cell in other sheet (sheet2). What i need is that when the M4 or/and N4 changes my code runs, and this code is in sheet1.
What am i missing here? With this code it will only change when i click M4 or N4.

Thanks in advance

Please Login or Register  to view this content.

[JBeaucaire]

1) You'll need to use the Worksheet_Calculate event.
2) You'll need to store the values of M4 and N4 somewhere static so you have something to compare to. For this exercise, I'll store them in AM4 and AN4 for the time being.

Put this code into the Sheet module:

Please Login or Register  to view this content.

[bazofio]

Thanks for the help JBeaucaire.
I just don't understand what you mean in point 2. Get them static how? I get them from another sheet, in M4 there is a formula ( =INT(L4/5/1000)*5) that gives me the result that i want to find (L4 is a link from a value in C6 in sheet2), and in N4 is a link to a value in E6 in sheet2.