Jim, I have wanted to know how to do this for a long time, but I need a
little more explanation on how to employ your code. Where in the code
that I have below would I insert your code? Obviously, I don't want
the column (A) hard-coded in the macro, thus the need for a pause.


Code:
--------------------
Sub ColDataValidation()
'
' ColDataValidation Macro
' Macro recorded 10/19/2005 by neopolitan'

'
With Selection.Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=countif(A:A,$A1)<=1"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub
--------------------


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=477565