Thread: Data validation and empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kris Kris is offline
external usenet poster
  
Posts: 58
Default Data validation and empty cells

range("d1").Validation.add formula1:=
"=$A$1:$A$7",Type:=xlValidateList,operator:=xlBetw een


How to avoid empty entries in drop down box if some of cell from A1:A7
are empty?

Thanks
Reply With QuoteReply With Quote