Got same error in this line Object temp = range.Cells[i][0].Value; Solved with non-zero based index Object temp = range.Cells[i][1].Value; How is it possible that the guys who created this library thought it was a good idea to use non-zero based indexing?
It is actually possible albeit complex. I am reposting this piece of magic from Kevin Jones aka Zorvek as it sits behind the EE Paywall (link attached if anyone has access) While Excel strictly forbids a UDF from changing any cell, worksheet, or workbook properties, there is a way to effect such changes when a … Read more
I’ve been evaluating these options and here’s the conclusion that I came to. MAF is a true addon framework. You can separate your addons completely, even running them inside a separate app domain so that if an addon crashes, it won’t take down your application. It also provides a very complete way of decoupling the … Read more