| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with UDF
Maybe thats is the onkly solution.
Jan Joel wrote: Then use a worksheet changge function rather than a formula. the problem is when a formula is a function of another cell you can't tell which cell change to trigger the worksheet re-calculation using the UDF. The worksheet change will know which cell actually caused the worksheet to be caculated. "Jan Kronsell" wrote: The problem is, that this returns the columns the UDF id places in, or have I misunderstood something? In column A in one sheet I have this formula: =flopslag(I2;COUNTIF($I$2:I2;I2);Opslag;2), where FLOPSLAG is my UDF. Opslag is a named array in another sheet. This formula is copied to about 60.000 rows in the sheet. WheneverIi type something anywhere in the sheet the all the formulas are recalculated, which takes about 30 minutes. The prolem is, that the output of the formulas only change, if I type in column A, so I want to avoid recalculation if I change anywhere else than column J. Jan Joel wrote: Use the following Col = Application.Caller.Column |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Threaded Mode
