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