E
eggpap
Hello,
is the SpecialCells method usefull to increase the speed of udfs?
Emiliano
is the SpecialCells method usefull to increase the speed of udfs?
Emiliano
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
Depends what you are doing. In general if there is a UDF that could use one
of the special cells features then yes it would be faster...
of the special cells features then yes it would be faster...
D
Dave Peterson
I don't think you can use .specialcells in UDFs that are called by a formula in
a worksheet cell.
a worksheet cell.
J
Jim Thomlinson
That is a new one on me... If you use the function withing code special cells
works just fine. If you call the function from a cell it doesn't. Not too
sure why that is but... so it is...
works just fine. If you call the function from a cell it doesn't. Not too
sure why that is but... so it is...
D
Dave Peterson
The best guess I saw (and I don't remember who posted it) is that excel sees
..specialcells as trying to do something to the worksheet (like selecting a
different cell--or assigning a value to a different cell).
But it's not too satisfying, huh?
..specialcells as trying to do something to the worksheet (like selecting a
different cell--or assigning a value to a different cell).
But it's not too satisfying, huh?
J
Jim Thomlinson
Yet one more thing in my life that I just have to file under "I'll be darned"
D
Dave Peterson
I think it was xl2k (or xl2002????) that allowed range.find in UDF's, too.
That list gets pretty big pretty fast, huh?
<vbg>
That list gets pretty big pretty fast, huh?
<vbg>
Jim said:Yet one more thing in my life that I just have to file under "I'll be darned"