2 user-defined function questions

[patl]

If a function accepts a variant, how can you tell on the function side if the variant is a Range?

Also, is there a way to compile user-defined functions and put them in a global library? Thanks a lot.

 

[Legacy 98055]

If a function accepts a variant, how can you tell on the function side if the variant is a Range?

Try this UDF to understand and see "TypeName" in VBA help for more info...

Public Function IsRange(Arg As Variant) As Boolean
    IsRange = (VBA.TypeName(Arg) = "Range")
End Function

Also, is there a way to compile user-defined functions and put them in a global library?

You can place them in a standard module withing Personal.xls, in an Excel addin, or as a COM addin...

Tom