This blog will contain useful tips and tricks to make using Excel easier. It's a great piece of software, but is so complex that it takes years to master. Luckily The Master of Excel is here to help!
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