Application.WorksheetFunction

Hi all,

Is there any difference in using Application.WorksheetFunction over WorksheetFunction in VB?

Thanks

See this article

That article is inside-out from the question. The question is what is the difference between using

Application.WorksheetFunction.<function>

and

WorksheetFunction.<function>

There isn't any difference between these two. WorksheetFunction is a property of Application where Excel is the application. If you omit Application as a qualifier, the default is Excel, and the same function is invoked. I was surprised to find out the qualifier is not required, as I just verified, because it is required for other properties like ScreenUpdating.

The article, OTOH, talks about the difference between

Application.WorksheetFunction.<function>

and

Application.<function>

which is different.

IMO, you should always use Application.WorksheetFunction as I have seen instances where it fails without the Application qualifier.