title: Identify and Paste the named range that was most recently updated
body: <p>I am trying to use VBA to identify the name of the named range that was most recently updated. I have been trying to use Worksheet Changes but have not gotten anywhere. In other words, if I have three named ranges "A", "B", and "C" all on the same worksheet and the named range "B" is changed. I want the name "B" not the data in the range to be pasted in a cell on a different worksheet. Thank you for any help.</p>