This project has moved and is read-only. For the latest updates, please go here.

DataValidation Property is Not Getting Exposed with Range()

Aug 7, 2013 at 2:41 PM
   I want to Validate a Range of Data in Excel, i am having one Column whose length i want to get fixed , according to the Example given Documentation we can apply DataValidation on Range Function , but in my Code i am not able to find DataValidation property in Case  of Range Method. Please Help me with this or tell me how to implement DataValidation on Entire Column rather than a single cell.
Thanks and Regards,
Aug 7, 2013 at 3:00 PM
Do you mean something like ws.Column(1).SetDataValidation().List(ws.Range("A1:A5")) ?

If not, how do you do it in Excel?