Can you name function?

[checkQ]

This is an odd one. I have not seen this question discussed anywhere on this
forum. Can you name a function? i.e. =Sum(A1:B2). I know that you can name
the whole formula =Sum(A1:B2) and call it "Addup" or you can just name the
range (A1:B2) and call it "Addup" but can you name the function Sum?

 

[Gary''s Student]

You can surely create an alias for a function:

Public Function zum(r As Range) As Variant
zum = Application.WorksheetFunction.Sum(r)
End Function

But why?

 

[checkQ]

Hi,
Thanks for response. I just wanted to see how far I could stretch the naming
function. Neat.