Gowri A

Gowri A

  • NA
  • 54
  • 47k

how can we use excel indirect function in c#

Jun 28 2014 3:02 AM
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)