Select A1:A10 and DataValidationAllowCustom

In dialog box enter =ISTEXT(A1)

A2:A10 will also be given the DV

Watch out that Excel doesn't add $ signs to the cellref.


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 09:32:01 -0800, Robert T <Robert
wrote:

I'm preparing a worksheet and need to have a range of cells to allow
alpha-only data entry, the validation option is not working for me unless I'm
missing something.