document.write('<div class="feedburnerFeedBlock" id="microsoft/mKHzk11vd23ul5rr7np2q04egp0k40">');
document.write('<p class="feedTitle">Custom Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/170787" target="_blank" >Description of limitations of custom functions in Excel</a></span>');
document.write('<div>Lists the functionality limitations of user-defined functions in Excel. These functions are called by a formula in a worksheet cell and cannot change the environment of Excel.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248822" target="_blank" >How to use custom functions with the Spreadsheet component</a></span>');
document.write('<div>Describes how you can create, deploy, and use a COM object with the Spreadsheet component.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/151582" target="_blank" >Methods to Use Custom Functions with Varying Arguments</a></span>');
document.write('<div>Using Microsoft Excel, you can create user-defined functions that can be called from a worksheet. These functions accept arguments in their function calls that can be of any type.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/163542" target="_blank" >XL97: Calculation Problems with Arrays in Custom Functions</a></span>');
document.write('<div>When you use a custom function in a workbook, the function may return incorrect values. Recalculating the workbook may also take longer than it does in earlier versions of ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/141288" target="_blank" >XL: How to Use a Custom Function in Another Workbook</a></span>');
document.write('<div>In Microsoft Excel, you can create custom Microsoft Visual Basic for Applications functions to perform calculations. By default, these custom functions are available to all ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213277" target="_blank" >XL2000: Methods to Use Custom Functions with Varying Arguments</a></span>');
document.write('<div>Using Microsoft Excel, you can create user-defined functions that can be called from a worksheet. These functions accept arguments in their function calls that can be of any type.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/134943" target="_blank" >Evaluate Method Affects Volatility of Custom Functions</a></span>');
document.write('<div>In the versions of Microsoft Excel listed above, a custom function created using Microsoft Visual Basic for Applications may not return the expected result.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/139574" target="_blank" >XL: Returning Address of the Cell with Largest or Smallest Value</a></span>');
document.write('<div>Using Custom Functions Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/144508" target="_blank" >Using Calculate Method May Not Calculate Certain Formulas</a></span>');
document.write('<div>When you calculate values on a worksheet, formulas that refer to cells that contain custom functions may not be calculated correctly.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/253819" target="_blank" >XL2000: Recalculation of UDFs and XLLs Gives Unexpected Results That ...</a></span>');
document.write('<div>When you use custom functions (UDFs) inside stand-alone dynamic-link libraries (XLLs), together with Microsoft Visual Basic for Applications custom functions, Excel may produce ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/167179" target="_blank" >XL97: Returning Data with DAO to a Custom Worksheet Function</a></span>');
document.write('<div>Microsoft Excel allows you to create custom functions using Visual Basic for Applications. You can also use Data Access Objects (DAO) to programmatically return information from an ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214260" target="_blank" >HOW TO: Create Functions to Calculate Light Years in Excel 2000</a></span>');
document.write('<div>Microsoft Excel does not include a function that converts miles into light years or light years into miles. This article explains how to create custom functions to make these ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/108280" target="_blank" >Function to compute average without high and low values</a></span>');
document.write('<div>For more information about using custom functions, click the Index tab\/button in Microsoft Excel 97 Help or MS Excel Help, type the following text</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213645" target="_blank" >XL2000: How to Use a Custom Function in Another Workbook</a></span>');
document.write('<div>In Microsoft Excel, you can create custom Microsoft Visual Basic for Applications functions to perform calculations. By default, these custom functions are available to all ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213710" target="_blank" >XL2000: Returning Data with Data Access Objects (DAO) to a Custom ...</a></span>');
document.write('<div>With Microsoft Excel, you can create custom functions using Visual Basic for Applications. You can also use Data Access Objects (DAO) to programmatically return information from an ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/264626" target="_blank" >Description of Excel 2000 specifications</a></span>');
document.write('<div>... shows only the first 251 scenarios Changing cells in 32 a scenario Adjustable cells 200 in Solver Custom functions Limited by ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213375" target="_blank" >XL2000: How to Return the Address of the Cell with the Largest or ...</a></span>');
document.write('<div>Using Custom Functions Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/184636" target="_blank" >XL98: Using Calculate Method May Not Calculate Certain Formulas</a></span>');
document.write('<div>When you calculate values on a worksheet, formulas that refer to cells that contain custom functions may not be calculated correctly.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/172996" target="_blank" >XL97: List of Fixed Problems in MS Excel 97 for Windows, SR- 1</a></span>');
document.write('<div>163542 (http:\/\/support.microsoft.com\/kb\/163542\/EN-US\/ ) XL97: Calculation Problems with Arrays in Custom Functions</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/166461" target="_blank" >XL97: ROW And COLUMN Functions Are Not Recalculated</a></span>');
document.write('<div>You can create custom functions in Visual Basic for Applications to use in place of the ROW and COLUMN functions that are built into Microsoft Excel.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687829.aspx" target="_blank" >Programming with the C API in Excel 2007</a></span>');
document.write('<div>It enabled users to create custom commands and functions on special Macro sheets that look like ordinary worksheets. XLM macro sheets are still supported in Excel 2007.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/117231" target="_blank" >Macro On Workbook Is Not Defined Error While Updating Links</a></span>');
document.write('<div>NOTE: Any formulas that call custom functions in a moved add-in display the full path to the previous location of the add-in. On the Tools menu, click Add-Ins.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/default.aspx/ph/2512?sid=202" target="_blank" >Excel 2003 Solution Center</a></span>');
document.write('<div>Description of limitations of custom functions in Excel Lists the functionality limitations of user-defined functions in Excel. These functions are called by a formula in a ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/150363" target="_blank" >How to Use a VBA Macro to Sum Only Visible Cells</a></span>');
document.write('<div>For more information about creating custom functions in Microsoft Excel 97, from the Visual Basic Editor, click the Office Assistant, type function statement, click Search, and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248174" target="_blank" >XL2000: Formulas Calculate Incorrectly After Changing Worksheet Name</a></span>');
document.write('<div>Your workbook uses one or more custom functions that are written in Microsoft Visual Basic for Applications. -and-Your workbook uses one or more custom functions that are ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248179" target="_blank" >XL2000: Calculation Problems When Custom Function Creates a Defined ...</a></span>');
document.write('<div>You should design your custom functions so that they only use the return value to change the value or text of the cell that called the function. NOTE: If the custom function passes ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/108425" target="_blank" >How to Create Add-in Application Name and Description</a></span>');
document.write('<div>In the versions of Microsoft Excel listed above, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom menus ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/158355" target="_blank" >XL97: ParamArray Must Be Declared as an Array of Variant</a></span>');
document.write('<div>151582 (http:\/\/support.microsoft.com\/kb\/151582\/EN-US\/ ) XL: Methods to Use Custom Functions with Varying Arguments</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/278328" target="_blank" >XL2002: How to Mark an Automation Add-In Function as Volatile</a></span>');
document.write('<div>When to Use Volatile Functions When Excel calculates a cell that contains a custom function, it recalculates all cell ranges that are passed as arguments to that custom function.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/182649" target="_blank" >XL98: ParamArray Must Be Declared as an Array of Variant</a></span>');
document.write('<div>151582 (http:\/\/support.microsoft.com\/kb\/151582\/EN-US\/ ) XL: Methods to Use Custom Functions with Varying Arguments</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/171659" target="_blank" >XL97: Syntax Errors Calculating Functions or Opening a Workbook</a></span>');
document.write('<div>When you recalculate values in a Microsoft Excel workbook that contains a custom function, the Visual Basic Editor may be started and you may receive the following error message ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/260893" target="_blank" >Works: Spreadsheet Functions Imported from Excel 2000 to Works</a></span>');
document.write('<div>Works: Spreadsheet Functions Imported from Excel 2000 to Works ... The default Excel cell format for this function is Custom m\/d ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214298" target="_blank" >HOW TO: Create an Add-in Application Name and Description in Excel ...</a></span>');
document.write('<div>In Microsoft Excel, you can create an add-in application that contains any of the following elements: functions, custom dialog boxes, custom menus, toolbars, and procedures.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/171640" target="_blank" >XL97: Illegal Operation Occurs While Recalculating Workbook</a></span>');
document.write('<div>The workbook contains user-defined (custom) functions. -and-You force the workbook to be recalculated by pressing the keys CTRL+ALT+F9.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213691" target="_blank" >XL2000: Syntax Errors When Calculating Functions or Opening a Workbook</a></span>');
document.write('<div>When you recalculate values in a Microsoft Excel workbook that contains a custom function, the Microsoft Visual Basic Editor may be open and you may receive the following error ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/265023" target="_blank" >XL2000: Memory Leak When Excel Calculates User-Defined Functions</a></span>');
document.write('<div>Microsoft Excel may leak memory when a custom function, also known as a user-defined function (UDF), is calculated.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687838.aspx" target="_blank" >Functions in the Stock Web Service DLL</a></span>');
document.write('<div>You can view and edit it by opening the XLAM document in the Custom UI Editor Tool. ... Excel 2007 XLL SDK Documentation API Function Reference Functions in the Stock Web Service DLL</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/194983" target="_blank" >PRB: Round Function different in VBA 6 and Excel Spreadsheet</a></span>');
document.write('<div>196652 (http:\/\/support.microsoft.com\/kb\/196652\/EN-US\/ ) HOWTO: Implement Custom Rounding Procedures</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/110076" target="_blank" >Cannot Remove Entries from Add-Ins Dialog Box</a></span>');
document.write('<div>Add-ins are custom commands or functions that appear to be part of the Microsoft Excel application. To install an add-in: From the Tools menu, choose Add-ins.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213828" target="_blank" >XL2000: Cannot Specify Number of Digits with FIX() or INT() Functions</a></span>');
document.write('<div>Custom Function to Simulate the TRUNC() Function with the \"num_digits\" Argument ... Basic Editor, click Microsoft Visual Basic Help on the Help menu, type int, fix functions in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/134406" target="_blank" >Custom Function to Transpose Nonadjacent Range</a></span>');
document.write('<div>... Applications, you can create a custom function that will turn a nonadjacent selection of cells into an array. This is beneficial with many of the built-in Microsoft Excel functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/171719" target="_blank" >TREND Function Works Differently in Functions Than in Macros</a></span>');
document.write('<div>TREND Function Works Differently in Functions Than in Macros ... You can use the TREND function in a custom function like you do in a spreadsheet.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213690" target="_blank" >XL2000: The Trend Function Works Differently in Functions Than in ...</a></span>');
document.write('<div>XL2000: The Trend Function Works Differently in Functions Than in Macros ... Applications macro, the function behaves differently than when you use it in a custom ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687861.aspx" target="_blank" >Creating XLLs and DLLs that Call Back into Excel</a></span>');
document.write('<div>Whereas xlAuto functions take or return the old data type XLOPER, new versions are ... The function can be used to display a custom dialog box that tells the user that the add ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687915.aspx" target="_blank" >How to: Access DLLs in Excel</a></span>');
document.write('<div>Functions should return types that VBA can recognize ByVal. This means that some types are ... also lets you attach the command to an element of the user interface, such as a custom ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687833.aspx" target="_blank" >How to: Access Excel Instance and Main Window Handles</a></span>');
document.write('<div>For example, these handles are useful when you are creating and displaying custom Windows dialog boxes. There are two XLL-only C API functions that provide access to these handles ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213403" target="_blank" >XL2000: Custom Function to Turn Nonadjacent Cells into an Array</a></span>');
document.write('<div>... for Applications, you can create a custom function that will turn a nonadjacent selection of cells into an array. This is useful with many of the built-in Microsoft Excel functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/223990" target="_blank" >XL98: Certain Functions Calculate Differently in Early Versions of ...</a></span>');
document.write('<div>Because these functions were improved, they return different values than in Microsoft Excel ... support.microsoft.com\/kb\/223314\/EN-US\/ ) XL98: Custom ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/142152" target="_blank" >How to Create Functions to Calculate Light Years</a></span>');
document.write('<div>How to Create Functions to Calculate Light Years ... To do this, select the Format menu, and choose Cells, the Number tab and Custom.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/110854" target="_blank" >XL: How to Compute the Periodic Annual Interest Rate in Microsoft ...</a></span>');
document.write('<div>You must use a manually entered formula to determine the annualized interest rate for an investment with more than one compounding period per year. You can also use a custom ...</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/mKHz"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');