VBA for data validation --> Method 'Add' of object 'Validation' failed

for some reason I can't get it to work it wright
even copiying the code from the help file will not work

any clue what could be going on?

With Range("e5").Validation
.Add Type:=xlValidateWholeNumber, _
AlertStyle:=xlValidAlertInformation, _
Formula1:="5", Formula2:="10"
.InputTitle = "Integers"
.ErrorTitle = "Integers"
.InputMessage = "Enter an integer from five to ten"
.ErrorMessage = "You must enter a number from five to ten"
End With

error number -2147417848
error helpcontext 1000440

error description : Method 'Add' of object 'Validation' failed