SpecialCells

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

Dave Peterson

I don't think you can use .specialcells in UDFs that are called by a formula in
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...
 
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?
 
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>

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