Lesson 9: Advanced Excel VBA: Harnessing Application.WorksheetFunction For Business Simulations
What, there's even more to Excel VBA? Unbelievably, there is! In this lesson, we go deep into the Excel VBA toolkit and explore some of its most powerful features. Application.WorksheetFunction allows us to harness the power of worksheet formulae without having to input formulae into the spreadsheet. Mind-bending, I know! It's a difficult one, so take your time. And, remember to punch the air if (when?) it works!
2 Lessons