I seem to be going in circles with trying to write an excel function. I'm
trying to create a function that takes in a set of business rules and scheduling
constraints and outputs the results to a range of cells but I’m unsure of the
structure of the formula.
I would like to create the public function
BusinessResults (ByVal BusinessRules As Range, ByVal BusinessConstraints As
Range) As Range
…
BusinessResults.Range(application.caller.address).offset(rowIndex,
ColumnIndex) = 411
…
Can you get me going on the right path?