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;