I get an error "Application-defined or object-defined error" when validating
input in cell N4 of my worksheet. For other cells in the worksheet (columns
A-K) it works fine. I've checked all settings, there's no difference with
other cells. What's wrong ?

I use the following code:

With Worksheets(1).Range("N4").Validation
.Add Type:=xlValidateWholeNumber, _
AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:="1", _
Formula2:="8"
.ErrorMessage = "Enter digit between 1 and 8"
.ShowInput = False
.ShowError = True
End With

If I put in on error resume next, I don't get an error, it works fine.
But: excel shows : value must be between 1 and 8 iso. my error message
...... !

Is this an Excel 2003 bug ? How to resolve this ?