Macro to show which cells have validation
Hello!
Anyone know a code to go through the active sheet, look for any cells
that have validation, and shade them purple? I am modifying an older
workbook, and there are stray cells with no data or formula, just
validation, so I am trying to track them down.
I guess a "For each ws in Workbook" code would be easier.
Thanks for any help!
VR/
Lost
|