Hello again. It has been a while since I've been on. I haven't done any programming for a long time. I have a worksheet where I would like to trigger a macro that I've written when a cell value changes. The cell value is calculated using a formula so the event needs to be triggered by the value changing not hitting enter in the cell. I can trigger the event using the following

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A6:N100")) Is Nothing Then
Call Fill
End If
End Sub
I would like to change it so that it only calls the macro Fill if the calculated value in Column N changes. The above is an uneducated programmers way of cheating the system so that it always triggers no matter which value I change. This makes it trigger when any number is changed though. I only want it to trigger when a number that effects the calculated value in Column N is changed.

Thanks again for your help.