There's a call getDataValidations for the Sheet class, that returns all the DataValidations for the sheet.
As a sheet may have many DataValidations, and those data validations may theoretically overlap, it's theoretically possible for a single cell to have more than one constraint in force at the same time. I have not been able to create this situation, however. Excel seems to insist that data validation be applied uniformly within a region. I'm not complaining, I'm just trying to figure out if it's something I should look for (more than one validation per cell). -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 blake.wat...@pnmac.com <melanie.petros...@pnmac.com> www.PennyMacUSA.com <http://www.pennymacusa.com/>