Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

291320 - 2007: How to use macro examples to delete duplicate items in a list in Excel 2002

291069 - 2007: Visual Basic Macro Examples for Working with Arrays

Knowledge Base Articles - 2003

832136 - 2003: Data may be truncated when you transfer array data to cells in an Excel worksheet

141692 - 2003: Visual Basic Example to Retrieve Value from Last Cell

818808 - 2003: You may receive a 'Run-time error 1004' error message when you programmatically set a large array string to a range in Excel 2003

Knowledge Base Articles - 2002

325703 - 2002: AutoCalculate feature is working even if that feature is turned off

283626 - 2002: Can Only Find Exact Matches When You Find Formats Based on a Cell

287102 - 2002: Data in Target Cells Is Lost When You Use Paste Special Command

287126 - 2002: Error Message: Microsoft Excel Cannot Find a Match

117128 - 2002: Hidden Cells in a Worksheet May Become Unhidden

291300 - 2002: How to Delete Cells with a For Each...Next Loop

287392 - 2002: How to Programmatically Turn Off the Clipboard Warning Message

291304 - 2002: How to Select Ranges Using Visual Basic for Applications (Novice Examples)

105111 - 2002: Sorting Feature Ignores Hidden Rows

280590 - 2002: Unable to Drag Information Between Multiple Workbooks

Knowledge Base Articles - 2000

213548 - 2000: '255 Characters in Cell' Error When Copying Worksheet

211821 - 2000: 'Cannot Change Part of a Merged Cell' Error When You Drag a Merged Cell Over Another Merged Cell

215710 - 2000: 'Insert Copied Cells' Menu Item Missing After Copy

213967 - 2000: AutoSelect May Detect a Double Header

211587 - 2000: CTRL+SHIFT+' Keyboard Shortcut Limited to 1024 Characters

211635 - 2000: Cannot Drag Cells When You Use AutoFilter

212097 - 2000: Cannot Use Keyboard to Move to Partially Hidden Merged Cells

214103 - 2000: Cells Made Blank with Quotation Marks Act As Text Cells

282929 - 2000: Copying and Pasting Special Text Freezes Excel Sessions

211965 - 2000: Data Overwritten Copying More Than 31737 Characters

214051 - 2000: Data Sort Selects an Incorrect Range

231007 - 2000: Deleting a Cell Changes the UsedRange Property

213242 - 2000: EnableSelection Property May Be Overridden

213657 - 2000: Error Message When Using Paste Method Without Moving Active Cell

214080 - 2000: Error Message: That Command Cannot Be Used on Multiple Selections

214266 - 2000: Error Message: The Command You Chose Cannot Be Performed with Multiple Selections

213326 - 2000: Error When You Use Array with Range Method

213812 - 2000: Goto Method Fails When Custom Dialog Box Is Visible

213544 - 2000: How to Delete Cells with a For Each...Next Loop

213797 - 2000: How to Populate an Array with a Discontiguous Range

213472 - 2000: How to Use Visual Basic Code to Total Rows and Columns in an Array

213193 - 2000: How to Use the SelectionChange Event to Make the Active Row Bold

213367 - 2000: How to compare data in two columns to find duplicates in Excel

142588 - 2000: How to compare two cells and ignore leading and trailing spaces by using the TRIM worksheet function

244435 - 2000: How to reset the last cell in Excel

213805 - 2000: Macros to Loop Through Range and Act Based on Cell Value

209358 - 2000: Paste All Not Available with Drawing Object on Office Clipboard

215250 - 2000: Paste Special Transposition Has Unexpected Results

245541 - 2000: Pasted Data May Include Hidden Cells

213542 - 2000: Range.PasteSpecial Changes Selection

214379 - 2000: References Updated Incorrectly After You Insert Cells

214346 - 2000: Rich Text Formatting Is Lost When You Use Replace All

213766 - 2000: Sample Macro to Remove User Name from Comment

213625 - 2000: Sample Macro to Sort List Based on Custom Sort Order

221188 - 2000: Second Paste from Office Clipboard Clears Bounding Outline and May Change Value

213579 - 2000: Select Method May Select More Cells Than Expected

213580 - 2000: Text Property Limited to 1024 Characters

211969 - 2000: The Cell Disappears When You Edit Text in the Cell

Knowledge Base Articles - 1997

159729 - 1997: '255 Characters in Cell' Error when Copying Worksheet

168956 - 1997: 'Cannot Change Part of a Merged Cell' Error When You Drag a Merged Cell Over Another Merged Cell

196620 - 1997: 'Cannot Empty the Clipboard' Error Message When Dragging Cells

178240 - 1997: AutoCalculate Is Inconsistent with Hidden Rows or Columns

156836 - 1997: CTRL+SHIFT+' Keyboard Shortcut Limited to 1024 Characters

182771 - 1997: Cannot Drag Cells When You Use AutoFilter

172823 - 1997: Cant Move to Partially Hidden Merged Cells with Keyboard

160767 - 1997: Cursor and Cell Disappear Editing Text in Cell

162047 - 1997: Cutting and Pasting Cells Causes Invalid Page Fault

161241 - 1997: Data Overwritten Copying More Than 31737 Characters

108484 - 1997: Data Sort Using Incorrect Guess Range

169812 - 1997: Entire Text File Appears In a Merged Cell

100715 - 1997: Error Message 'That Command Cannot Be Used on Multiple Selections'

040401 - 1997: Errors Sorting Cells That Contain References

253822 - 1997: Excel Interprets Euro Values as Text

139882 - 1997: How to Compare Data in Two Columns for Duplicates

139573 - 1997: How to Count Blank Cells in a Specified Range

141181 - 1997: How to Make Sure That Only Numbers Are Entered in a Column

174537 - 1997: How to Sort Cells Without Sorting Linked Cells

147959 - 1997: Incorrect Cell Range Selected When Activating Excel Object

171026 - 1997: Page Fault Pasting Array Formula Between Workbooks

083813 - 1997: Pasting Non-Contiguous Range to Microsoft Word

161688 - 1997: Pasting in Merged Cell Duplicates Copied Cells

157499 - 1997: Picture Linked to Cell Does Not Immediately Update

107568 - 1997: Pipe Symbols Disappear When Exported to Lotus

229107 - 1997: Problem Using Sort Method with More Than One Key

171281 - 1997: Problems with Arguments of PasteSpecial Method

255520 - 1997: Problems with Arguments of PasteSpecial Method

126931 - 1997: Sorting Alphanumeric Text as Numeric Values

168434 - 1997: Text Is Truncated to 255 Characters After You Use Justify Command

159958 - 1997: Unexpected Results Paste Linking Noncontiguous Range

169353 - 1997: Window Vanishes/Stops Responding After Inserting Cut Cells