ExcelBanter - View Single Post - Data validation and empty cells

Thread: Data validation and empty cells

View Single Post

#1

Report Post

Posted to microsoft.public.excel.misc

Kris

Posts: n/a

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 Quote

Reply With Quote