I'm programming an excel sheet using VS2008 in VB.Net and cannot get a line of code to work.
I'm trying to programatically add format conditions to a particular range in an excel sheet but I keep getting the same error: "Number of parameters specified does not match the expected number."
Usually I just create a macro in Excel and then see the code it produces - this gives me a pretty good indication of how to program in VB.Net. This time however it didn't seem to work.
I'm importing Microsoft.Office.Interop.E
oExcel.WorkSheet.Range("B1:B10").FormatConditions.Add(XlFormatConditionType.xlCellValue, XlFormatConditionOperator.xlLessEqual, "0")