| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro Excel problem link cells with Data-Validation option | Excel Discussion (Misc queries) | |||
| one column of cells show ####. Values show when I open it. Help | Excel Discussion (Misc queries) | |||
| using a macro to apply data validation to several cells | Excel Programming | |||
| macro to hide then show cells | Excel Discussion (Misc queries) | |||
| Macro to show wraped text in merged cells | Excel Programming | |||
Threaded Mode
