J-Walk & Associates, Inc.

Get The PUP Functions

My Power Utility Pak add-in includes 53 new worksheet functions that you can use in your formulas. Here's the best part (for you): You can use these functions even if you haven't purchased a license for PUP.

From the PUP license agreement:

The PUP FUNCTION LIBRARY component of PUP copies VBA macros to an Excel workbook file. The PUP license allows such workbooks to be distributed to others. However, the VBA macros may not be included as part of any other commercial product.

Here's how to get the PUP worksheet functions:

1. Download the trial version of PUP. If you use Excel 2007, get PUP v7. Otherwise, get PUP v6.
2. Install the add-in. You can use the trial version for for 30 days.
3. Create an empty workbook.
4. Access the PUP Function Library dialog box. It's in the Formula Tools menu (or Ribbon control in Excel 2007).
   
   
   
5. Click the All button, to select all functions.
6. Click the Add Selected button to add the selected functions to your workbook.

All of the functions will be available in the workbook you created in Step 3. To use the functions in other workbooks, just copy the VBA module named modPUPFunctions to your workbook. Or, you can just copy and paste the functions that you use. Although the trial version of PUP expires after 30 days, the functions will work forever.

Using PUP to add specific functions to individual workbooks is a lot easier, but the method described here also works.

Keep in mind that if your formulas use any of the PUP functions, you most open the workbook with macros enabled. If you use Excel 2007, you must save your workbook in something other than XLSX format (for example, XLSM or XLS format).