That is great thank you, neat to see another way to execute it. I appreciate you sharing that. Here's also a similar link to an alternative way to do it. I think from yours I can automate getting the last executed macro since I can't seem to figure it out from what I was doing.
Update: I think what is happening is it is command clicking on Modified instead of Used icon. Perhaps those were reassigned positions. I'll see what I can figure out and repost.