1
Answer

how to use excel indirect function in c#

Gowri A

Gowri A

10y
908
1
Can u tell me how to use the formula =INDIRECT(A2) in c#
This function is working in excel but not working in c# any idea plz help me

 Excel.Range vehicle_makes_dropdown = xlWorkSheet1.get_Range("B2", "B101");
            string formula1 = "=INDIRECT(A2)";
            vehicle_makes_dropdown.Validation.Add(Excel.XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertInformation, XlFormatConditionOperator.xlEqual, formula1, misValue);
            vehicle_makes_dropdown.Validation.IgnoreBlank = true;
            vehicle_makes_dropdown.Validation.InCellDropdown = true;

Answers (1)