Received : 2007/11/19 11:38:06
Message : validation.Formula1 = "=INDIRECT(" + namedRange + ")";
if INDIRECT applies to the value that will be selected from another combox, then I should have:
validationList.Formula1 = "=INDIRECT(B14+"List")";
In excel it looks this way:
=INDIRECT($B$14 & "Sections")
I tried this:
workSheet.Cells[1, 0].Name + "& \"Sections\""
But I receive an Invalid Formula Exception
This message was posted using Aspose.Live 2 Forum