Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
how can we use excel indirect function in c#
Gowri A
Jun 28 2014 3:02 AM
1.3k
Reply
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;
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Microsoft.Office.Interop.Owc11 is not working for windows 7
Adding header in word documents which only comes MS officec#