Hi,

I have been spinning my wheels trying to figure out how to solve my problem.
I am not sure if using a UDF is the correct solution. I have read that UDF
cannot modify worksheets if they are called in a certain way, but can if they
are called another way. I have read about Excel Addins, COM Addins and UDFs
and feel confused on which of these will provide the solution.

What I want to do is provide a funtion that a user can use that will take in
parameters, and then return the result by modifing a range of cells. One of
the parameters passed in will be the starting cell for the resulting range.

I need to write most of this code (if not all) in C# (VB.NET). We are
trying to limit the amount of VBA code that we need in our solution.

Being pointed in the right direction is greatly appreciated.

Michael