Writing a Custom Function
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 [...]
Difference Between Sub and Function
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.
How Often Do You Use Excel Macros?
The second poll on Excel Hints just closed and I’d like to thank everyone who participated. One of my goals is to use these polls to gauge what the readers of Excel Hints are looking for. Which takes us to the most recent poll that just closed today: How often do you use macros?
