Hello,
I am trying to write some code to identify which, if any, named range(s) the active cell intersects. I have tried multiple methods and keep getting stuck...
The end goal is to create a change log but for now I just need to identify the names of the ranges being changed.
So far:
This code currently does not display any message whatsoever when I make a change to the sheet. Prior to deleting the Print_Area named range, it would always tell me I'm in the print area range and nothing else. Does anyone know why this is happening or a faster way to identify the named ranges the target intersects? Thank you.
Bookmarks