Thread: Data Validation List

I have a cell with list data validation to the cell named "TEST".
I would like the item "All" at the top of the list, but without addind it to the named range.
Maybe something like "All" & range("TEST")?
Attached is my problem...thanks in advance!

Attached is a couple of options

Hi, If Could perhaps add this "Selection Change "Event to your sheet.
NB:- Change Validation in "F1" to suit.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Target.Address(0, 0) = "F1" Then Range("F1") = "All"
End Sub

Regards Mick