Hi all,
Is there any difference in using Application.WorksheetFunction over WorksheetFunction in VB?
Thanks
Hi all,
Is there any difference in using Application.WorksheetFunction over WorksheetFunction in VB?
Thanks
Last edited by roger09; 09-28-2011 at 01:32 AM.
See this article
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
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 betweenApplication.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.
Remember what the dormouse said
Feed your head
Thanks to royUK, 6StringJazzer and romperstomper for your time.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks