Thread: Validation List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default Validation List

range("A1").Value =""

where a1 is the cell with the DV.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Modell" wrote in message
...
Is there a way to reset a validation list to "blank" or for example the

first
choice in the list in a macro?

Thanks.