View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lostguy Lostguy is offline
external usenet poster
 
Posts: 15
Default 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