Excel 2007 alone is a powerful tool for data analysis and number-crunching. But when you add VBA programming to your Excel workbooks and spreadsheets, your opportunities for transforming simple data into wonderful information are nearly endless. Use the following functions to create powerful Excel programs in VBA.
Excel 2007 VBA Programming Functions
By: John Walkenbach and Jan Karel Pieterse and
Updated: 03-26-2016
From The Book: Excel 2007 VBA Programming For Dummies