validation command
 

I have 31 pages each with the same range I want to progam to validate the entry. it works fine for page 1, but when I highlight more than 1 worksheet to do them all at once the Validation comand is unavalible. The worksheets are unprotected. It is not a shared workbook. Is there a way to program validation to all at once or at least copy, paste validation?

validation command
 

Nevermind that question, while i was typing the question I thought of copy paste and it does apear to work, but the custom formula for validation does not seem to be working, I want to warn unless a number between 1 & 60 is entered or the letter "N" entered. I tried - or(and(1,<60),<="n") -- but any number entry gives me the warning ?

validation command
 

The following will allow 2 to 59 or "n". Assuming that you enter this first
for A1 and then copy to other cells :

=OR(AND(A11,A1<60),A1="n")

hth,

Doug

"R Mills" wrote in message
...
Nevermind that question, while i was typing the question I thought of copy
paste and it does apear to work, but the custom formula for validation does
not seem to be working, I want to warn unless a number between 1 & 60 is
entered or the letter "N" entered. I tried - or(and(1,<60),<="n") --
but any number entry gives me the warning ?

validation command
 

Thanks that worked