Can you name function?
 

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?

Can you name function?
 

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?
--
Gary''s Student - gsnu200781


"checkQ" wrote:

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?

Can you name function?
 

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


"Gary''s Student" wrote:

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?
--
Gary''s Student - gsnu200781


"checkQ" wrote:

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?