Apr 16 2009
Run a Macro When Opening a Workbook
- Comments Off
There may be a time when you want a macro to run automatically every time you open a workbook. Excel has a built in way to help with this – the Auto_Open subroutine (Workbook_Open achieves a similar result). Each time Excel opens, Auto_Open() will run only once when the workbook is open. Let’s go ahead […]
Feb 12 2009
Difference Between Sub and Function
- Comments Off
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.