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
|