Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

221048 - 2007: Custom Function May Not Calculate Expected Value

170787 - 2007: Description of limitations of custom functions in Excel

213360 - 2007: How to convert a numeric value into English words in Excel

Knowledge Base Articles - 2002

235099 - 2002: Custom Function May Return Different Result When Opened as HTML File

214313 - 2002: How to Calculate the Number of Days in a Month

278328 - 2002: How to Mark an Automation Add-In Function as Volatile

277608 - 2002: Macro High Security Warning or User Defined Functions Display #Name?

Knowledge Base Articles - 2000

277017 - 2000: Cannot See User-Defined Function in the Paste Function Dialog Box

213361 - 2000: Conversion to Base x Function Not Available

213679 - 2000: Custom Function Returns #VALUE! Error After Running Macro

250828 - 2000: Custom Function Returns #VALUE! If Returning Array Larger Than 5461 Elements

213403 - 2000: Custom Function to Turn Nonadjacent Cells into an Array

213684 - 2000: Function That Uses the ActiveCell Property Returns Incorrect Result

213813 - 2000: How to Add a New Category to Function Category List

142152 - 2000: How to Create Functions to Calculate Light Years

213183 - 2000: How to Display a Custom Function in Step 2 of the Function Wizard

213484 - 2000: How to Return Multiple Values from a Custom Function

213645 - 2000: How to Use a Custom Function in Another Workbook

213449 - 2000: How to convert degrees/minutes/seconds angles to or from decimal angles in Excel 2000

265023 - 2000: Memory Leak When Excel Calculates User-Defined Functions

213277 - 2000: Methods to Use Custom Functions with Varying Arguments

213666 - 2000: Only One Character Is Returned by a Declared Function

253819 - 2000: Recalculation of UDFs and XLLs Gives Unexpected Results That Depend on Sheet Names

213710 - 2000: Returning Data with Data Access Objects (DAO) to a Custom Worksheet Function

266672 - 2000: Sample Macro to Determine If a Year Is a Leap Year

280094 - 2000: Sample user-defined function to hide formula errors in Excel

213691 - 2000: Syntax Errors When Calculating Functions or Opening a Workbook

213475 - 2000: User-Defined Function to Place Sheet Name in a Cell

211747 - 2000: User-Defined Functions Are Unexpectedly Calculated More Than Once

213294 - 2000: Visual Basic Function to Format Complex Numbers

213392 - 2000: Visual Basic Macro to Convert Number to a Different Base

215185 - 2000: Visual Basic Programming Errors Are Not Reported with User-Defined Functions

Knowledge Base Articles - 1997

163542 - 1997: Calculation Problems with Arrays in Custom Functions

172304 - 1997: Cannot Use User-Defined Function in Demand-Loaded Add- in

244466 - 1997: Cells That Contain User-Defined Functions Not Recalculated Return #Value

140035 - 1997: Conversion to Base x Function Not Available

186685 - 1997: Custom Function Is Not Recalculated with Intersection Operator

223312 - 1997: Custom Function May Not Calculate Expected Value

175226 - 1997: Custom Function Returns #VALUE! Error After Running Macro

216531 - 1997: Custom Function Returns #VALUE! If Returning Array Larger Than 5461 Elements

125723 - 1997: Custom Function Returns Incorrect Value/Appears to Hang

121944 - 1997: Custom Function to Express Degree to/from as Fractions of Degrees

134406 - 1997: Custom Function to Transpose Nonadjacent Range

166816 - 1997: Deleted 4.0 Macro Function Appears in Function Wizard

171362 - 1997: Error Message Calculating Custom Function in Formula Bar

168238 - 1997: Error Using Evaluate and User-Defined Add-In Function

175984 - 1997: GET.DOCUMENT Function Returns Incorrect Document Name

189165 - 1997: How to Display Custom Function in Function Wizard Step 2

141288 - 1997: How to Use a Custom Function in Another Workbook

183086 - 1997: Only One Character Is Returned from a Declared Function

201584 - 1997: Private Functions Are Available to Worksheet

264757 - 1997: Result Of Custom Function Appears In Another Workbook When Recalculated

139574 - 1997: Returning Address of the Cell with Largest or Smallest Value

167179 - 1997: Returning Data with DAO to a Custom Worksheet Function

110693 - 1997: Returning Multiple Values from a Custom Function

171659 - 1997: Syntax Errors Calculating Functions or Opening a Workbook

240370 - 1997: User-Defined Function Using Select Case Statement May Return #VALUE!

113392 - 1997: User-Defined Function to Put Sheet Name in a Cell

170308 - 1997: User-Defined Function with Application.Run Returns #VALUE!

170650 - 1997: VBE: User-Defined Functions Are Calculated Incorrectly

135635 - 1997: Visual Basic Macro to Convert Number to a Different Base