How do I exclude a value in data validation?
 

I want to exclude a value that I want visible in my data validation list. I
want it visible to show organization in a long list, but I don't want the
heading to be an allowable value. Help.

How do I exclude a value in data validation?
 

How about a change event macro.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("F1").Value = "Your Value" Then Range("F1").Value = ""
End Sub

HTH
Regards,
Howard

"Kindred Spirit" <Kindred wrote in message
...
I want to exclude a value that I want visible in my data validation list.
I
want it visible to show organization in a long list, but I don't want the
heading to be an allowable value. Help.