#VALUE will be the result e.g. if you have not the same spelling of r
in (r as Range) and in r.Value

To me the function work as expected for all cases you mention.

Lars-Åke

On Wed, 6 Aug 2008 13:11:03 -0700, John C <johnc@stateofdenial wrote:

I come up with #VALUE! errors, no matter when tested. static text, static
number, formulated text, formulated number, empty cell by formula, empty cell
because it's just empty.