When to use WorksheetFunction and when not?

[JohnKauffman]

When using a function within my code I can not figure out the logic of when to use WorksheetFunction and when not.

As test shows below, Sum() needs WorksheetFunction but ABS() fails with WorksheetFunction.
I usually figure it out by trial and error, but would like to understand the logic. I get a clue from intellisense options.
Are there two "classes" or groups of functions

ActiveCell.Value = WorksheetFunction.Sum(1, 2) 'Works
ActiveCell.Value = Sum(1, 2) 'Fails
ActiveCell.Value = WorksheetFunction.Abs(-5) 'Fails
ActiveCell.Value = Abs(-5) 'Works

 

[mikerickson]

You use WorksheetFunction when the function is a member of the WorksheetFunction class. Generaly that is when there is no VBA equivalent.

There is no VBA function Sum, there is a WorksheetFunction.Sum.
There is a VBA function Abs, there is no WorksheetFunction.Abs
There is a VBA function Replace, there is also a WorksheetFunction.Replace, but they do different things.

To get a list of all the WorksheetFunctions, look in the Object Browser.

 

[JohnKauffman]

Thanks, Mike. Sounds like there is no simple rule, although your general guideline makes logical sense.

 

[mikerickson]

The Object Browser would be definitive. (Plus, it is my most often used on-board help feature.)