Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Modify Worksheet Range when called by a UDF
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open worksheet when called through a function | Excel Programming | |||
add and remove rows from a called range | Excel Programming | |||
range.find method called into a VBA function (problem) | Excel Programming | |||
function called from worksheet and bad result! | Excel Programming | |||
Keeping name of worksheet who called macro | Excel Programming |