Snakehips
Well-known Member
- Joined
- May 17, 2009
- Messages
- 6,012
- Office Version
- 365
- Platform
- MacOS
I have many cells with data validation set to lists identified by named ranges. Does anybody know how I can use vba to return the name of the range that is assigned to each cell when it is selected and becomes the active cell?