Sorry - I should have explained a bit more.
The array that you get for an object[] or object[,] argument will contain objects of different types.
Each entry in the array will be one of the following:
- Double
- String
- Boolean
- ExcelDna.Integration.ExcelError
- ExcelDna.Integration.ExcelMissing
- ExcelDna.Integration.ExcelEmpty
You will never get a null in the array.
An empty cell will have type ExcelEmpty.
So your function might look like this:
public static object dnaTest(object[] DummyRange)
{
string Blank;
Blank="No";
if (DummyRange[0] is ExcelEmpty)
Blank="Yes";
return Blank;
}
Of course you might have other values like a string with a space in as the entry.
So you might check whether the value is a double to detect the first number.
-Govert