Hello All:

I'm creating a workbook and populating automatically with records
pulled from a database. I have two columns that need drop down list
validation. The first is working fine, but the second is derived from
the selection of the first with the following entry in the validation
property

string strValidation = string.Format("=INDIRECT($C${0})", idx);
Excel.Range subcatCell = oSheet.get_Range(strCellAddr, strCellAddr);
subcatCell.Validation.Add(XlDVType.xlValidateList,
XlDVAlertStyle.xlValidAlertStop, Missing.Value, strValidation,
Missing.Value);

Can anyone tell me if there is a limitation that precludes using a
derived range name?

-Bob