|
SpecialCells
Hello,
is the SpecialCells method usefull to increase the speed of udfs? Emiliano |
SpecialCells
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... -- HTH... Jim Thomlinson "eggpap" wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano |
SpecialCells
I don't think you can use .specialcells in UDFs that are called by a formula in
a worksheet cell. eggpap wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano -- Dave Peterson |
SpecialCells
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... -- HTH... Jim Thomlinson "Dave Peterson" wrote: I don't think you can use .specialcells in UDFs that are called by a formula in a worksheet cell. eggpap wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano -- Dave Peterson |
SpecialCells
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? Jim Thomlinson wrote: 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... -- HTH... Jim Thomlinson "Dave Peterson" wrote: I don't think you can use .specialcells in UDFs that are called by a formula in a worksheet cell. eggpap wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano -- Dave Peterson -- Dave Peterson |
SpecialCells
Yet one more thing in my life that I just have to file under "I'll be darned"
-- HTH... Jim Thomlinson "Dave Peterson" wrote: 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? Jim Thomlinson wrote: 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... -- HTH... Jim Thomlinson "Dave Peterson" wrote: I don't think you can use .specialcells in UDFs that are called by a formula in a worksheet cell. eggpap wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano -- Dave Peterson -- Dave Peterson |
SpecialCells
I think it was xl2k (or xl2002????) that allowed range.find in UDF's, too.
That list gets pretty big pretty fast, huh? <vbg Jim Thomlinson wrote: Yet one more thing in my life that I just have to file under "I'll be darned" -- HTH... Jim Thomlinson "Dave Peterson" wrote: 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? Jim Thomlinson wrote: 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... -- HTH... Jim Thomlinson "Dave Peterson" wrote: I don't think you can use .specialcells in UDFs that are called by a formula in a worksheet cell. eggpap wrote: Hello, is the SpecialCells method usefull to increase the speed of udfs? Emiliano -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 10:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com