[RESOLVED] validation macro doesn't work

[.paul.]

i've written a macro that selects a range of cells (that part works) then sets data validation for those cells. it doesn't cause an error but it doesn't stop alphabetic characters being typed in the cells as its supposed to.

heres my code:

With Selection.Validation
       .Delete
       .Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _
       Operator:=xlBetween, Formula1:=1, Formula2:=65536
       .IgnoreBlank = True
       .InCellDropdown = True
       .InputTitle = ""
       .ErrorTitle = "Integers"
       .InputMessage = ""
       .ErrorMessage = "You must enter a number from 1 to 65536"
       .ShowInput = False
       .ShowError = True
End With

what am i doing wrong?