I'm not a beginner, though I surprise myself at my occasional talent at brain damaged/senile inability to see the obvious. Here's something that just hit me for whatever reason after decades of coding.
If a Function fnFoo has As Range, then you can just go
i = fnFoo.Row
In all my lame thinking years I've gone
set rng = fnFoo
i = rng.Row
I never connected that you could directly use properties of a return value that's a range. Doh!!
Tell me if you know exceptions to using properties or methods directly against a function call.
Perhaps it's just because I normally return numbers or strings, and TMK I'm unaware of any properties that apply to nonobjects, whereas properties are often the only reason you access a Object
Bookmarks