Excel VBA tip: worksheet functions can be called from within VBA using Application.WorksheetFunction

Trying to do something within VBA that can be easily achieved using a formula in a cell on a worksheet?  You can probably use a VBA worksheet function.

Call a worksheet function by using Application.WorksheetFunction.  For example:

No comments:

Post a Comment