Yesterday I showed you how to create your own functions using Excel VBA, or Visual Basic for Applications. Today’s post will take this to the next level.
If you’ve played with creating and using your own functions, you may have noticed that once you close that workbook, you lose the ability to use that function. [...]
Posts Tagged ‘Excel’
Create Your Own Excel Add-Ins
Posted in Excel, tagged Add-In, Excel, VBA on 2008.06.20 | 2 Comments »
Create Your Own Excel Formulas
Posted in Excel, tagged Excel, Formulas, VBA on 2008.06.19 | 6 Comments »
How to use Excel VBA to hand-craft custom functions for spreadsheets requiring complex functions.
Calculated Items in Pivot Tables
Posted in Excel, tagged Excel on 2008.06.03 | 11 Comments »
Work with Excel pivot tables long enough and you will find yourself suffering many frustrations. For starters, there’s no way to create your own AutoFormats, so unless your company wants to use Microsoft’s idea of good-looking tables as its standard format, you’re prett much stuck with copy/pasting and doing your own formatting. This [...]
