i want to validate a cell which only accepts letters not numbers
i have tried this string but it is not working
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop, Formula1:="=AND(ISERROR(FIND(ROW(INDIRECT(""1:10"")) - 1, nm)))"
where nm is the named range in which i want to give validation



thank you.....