Microsoft’s Excel Blog has an interesting post breaking down the advantages of using either functions or pivotTables to do your analysis. There present the differences with a small example. Check out the comparison here: Analyzing Data: Functions or PivotTables
Using VBA, Excel lets you write custom functions that you can call from any cell in your worksheet (You can also call them from macros you create in VBA, but we’ll revisit this later). This feature is attractive when you are currently using a complicated formula to do some work in your spreadsheet, especially when […]
The difference between when to use Sub and Function in VBA can be confusing. Let’s take a look at some of the differences between the two and when they should be used. Using these two features correctly can greatly increase the flexibility of your designs.