Excel 2007 - Determine if range has data validation and extract all options to another cell 1

[BxWill]

Have a two column 300 record extract from a application that contains data validation for several ranges similar to

Name---------Mary Smith
Type---------Apt (validation; choices include "Apt","House")
Service------Buy (validation; choices include "Buy","Sell")
Date---------6/1/2012
.
.
.


If the cell contains validation, "List" is specified in the "Allow" testbox and all of the possible choices in the dropdown are displayed in the textbox titled "Source."

Is it possible, via a formula or VBA to determine if a cell contains data validation (then maybe display "yes" or "no" in column C and if so, output all of the possible options in another column(maybe column D)?

 

[SkipVought]

hi,

It is not clear whether your example represents the DATA within your sheet or the list in one of your Data Valisation lists.

Please clarify.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BxWill]

This represents data in the worksheet.