I'm trying to create a UDF in C# that will pull in a range of cells and do something with the contents of those cells. I cannot seem to get the correct fype for the formula parameter though. I have other formulas that are successfully pulling
in string parameters but I need to support a range of cell references too. Examples:
public string myFormula1(string myParameter)
DOES NOT WORK:
public string myFormula(NetOffice.ExcelApi.Range myRange)
var rowCount = myRange.Rows.Count;
What is the correct type for the range of cells argument?