tracking changes to formula results

[Kramxel]

Good Morning All,

I am looking to track changes to a specific section of cells, after doing some digging i've found and modified the code below that in general terms works but I am having a couple of problems tha tI can't yet solve.

Please Login or Register  to view this content.

1. The range "RL32:RR140" are all the results of a formula and code above will track changes to the cells that drive these results but not the result itself (that lies within the above range) - how can the code be modified to look at the results of the formula?

2. Column RK contains names of agents that I would like to be flagged in the log sheet, I can create the column entry within the log sheet but am at a loss at how I can for example after identifying a change to the formula result in cell RR48, get the value within RJ48.

Any Help will be appreciated, in the meantime i'll be heading back to Google.

[Kramxel]

please close/delete this! for some reason my posts aren't showing up in my recent posts and I couldn't remember if I had raised this (got distracted with something), so I have posted twice now. The other post now also have an example workbook.