SpecialCells

[eggpap]

Hello,

is the SpecialCells method usefull to increase the speed of udfs?

Emiliano

 

[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...

 

[Dave Peterson]

I don't think you can use .specialcells in UDFs that are called by a formula in
a worksheet cell.

 

[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...

 

[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?

 

[Jim Thomlinson]

Yet one more thing in my life that I just have to file under "I'll be darned"

 

[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>

Yet one more thing in my life that I just have to file under "I'll be darned"