Thread: Selective clearence
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gotroots Gotroots is offline
external usenet poster
  
Posts: 114
Default Selective clearence
Each cell in the range has data validation - Imput Message
How do I avoid this being deleted also.

Range("C5:D11,G5:G11").Select
Selection.Clear

Thank you if you can help.
Reply With QuoteReply With Quote