Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

061090 - 2007: How to use cell references and defined names in criteria in Excel

Knowledge Base Articles - 2003

259137 - 2003: How to determine whether a selected cell in an Excel worksheet is in a specified defined range by using a Visual Basic macro

119826 - 2003: Macro to Remove Hidden Names in Active Workbook

213413 - 2003: Visual Basic macro to show active cells range names in Excel

Knowledge Base Articles - 2002

058245 - 2002: Defined Names Not Sorted in Excel

291241 - 2002: Natural Language Formulas Return Error

Knowledge Base Articles - 2000

211851 - 2000: #NAME? Error Message After Linking or Updating Data

221058 - 2000: #REF! Error Recalculating Worksheet with Defined Name

213463 - 2000: 'Cannot Find Macro' Error Message When Running Macro from Object

213838 - 2000: Cannot Define a Name If the Active Sheet Is Protected

214283 - 2000: Consolidated Labels Use Name of Workbook Instead of Sheet Name

250825 - 2000: Copying Worksheet into Workbook Deletes Defined Name

248165 - 2000: Defined Name No Longer Present When You Open Workbook

213533 - 2000: Defined Names Are Case Sensitive

211873 - 2000: Defined Names Saved Incorrectly in Lotus 1-2-3 Format

213655 - 2000: Error Getting the Value of a Name in Visual Basic

211654 - 2000: Error Message When You Copy a Formula Containing a Label

214376 - 2000: Error Using Defined Name That Refers to a Constant Value

214061 - 2000: Global Names and Local Names Use Same Amount of Memory

200688 - 2000: Inconsistent Results Using Natural Language Formulas

211522 - 2000: Limit of Natural Language Formulas per Worksheet

248173 - 2000: Links to Closed Workbook with Defined Names Update Slowly

212157 - 2000: NLFs That Use Restricted Labels Return #VALUE! Error

268974 - 2000: Name Cannot Be Applied to Formulas on All Sheets in a Workbook

211754 - 2000: Natural Language Formula Returns Incorrect Results

211875 - 2000: Natural Language Formula Returns Zero Value

222170 - 2000: Natural Language Formulas Produce #NAME? Errors

199411 - 2000: Natural Language Formulas Return Error

214000 - 2000: Quattro Pro Defined Names in Microsoft Excel Formulas

213540 - 2000: Run-time Error 1004 Accessing Locally Defined Name

213432 - 2000: Sample Macro to Retrieve Defined Name of the ActiveCell

279412 - 2000: Use Natural Language Formulas in Excel 2000

213678 - 2000: Worksheet Change Event Error Occurs When Using the Names Property

Knowledge Base Articles - 1997

167379 - 1997: #NAME? Error After Linking or Updating Data

222844 - 1997: #REF! Error Recalculating Worksheet with Defined Name

108359 - 1997: Cannot Define Name If Active Sheet Protected

190204 - 1997: Copying Worksheet into Workbook Deletes Defined Name

186386 - 1997: Defined Name Formula Is Not Updated After Sort

160327 - 1997: Defined Names Are Case Sensitive in Microsoft Excel 97

171898 - 1997: Defined Names Display #REF! After Clicking Undo

166763 - 1997: Defined Names Saved Incorrectly in Lotus 1-2-3 Format

160543 - 1997: Error Evaluating Natural Language Formula

172709 - 1997: Error Saving or Closing Files with Defined Names

172370 - 1997: Error Using Natural Language Formula in a Macro

104999 - 1997: Global Names and Local Names Use Same Amount of Memory

161881 - 1997: How to Use Natural Language Formulas

192437 - 1997: Inconsistent Results Using Natural Language Formulas

157483 - 1997: Limit of Natural Language Formulas per Worksheet

104501 - 1997: Making All Identical Names in a Workbook Local

167989 - 1997: NLFs that use Restricted Labels Return #VALUE! Error

169397 - 1997: Name Box Functionality Has Changed

170455 - 1997: Natural Language Formula Returns Incorrect Results

166744 - 1997: Natural Language Formula Returns Zero Value

157095 - 1997: Natural Language Formulas Return Error

124930 - 1997: Quattro Pro Defined Names in Microsoft Excel Formulas