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
|