Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

213712 - 2007: Automation Example with Microsoft Word and Microsoft Outlook

213581 - 2007: Code 'Behind' Worksheet or Workbook May Not Work

213566 - 2007: How to Create Application-Level Event Handlers

213638 - 2007: How to Create a Macro That Counts Comments

213810 - 2007: How to Determine How Many Pages Will Be Printed

211736 - 2007: How to Display a Progress Bar with a User Form

213609 - 2007: How to Hide Sheets and Use xlVeryHidden Constant in a Macro

213389 - 2007: How to Programmatically Copy All Range Names

213257 - 2007: How to Set Page Setup Attributes for More Than One Sheet

089794 - 2007: How to use Visual Basic for Applications to count the occurrences of a character in a selection in Excel

199505 - 2007: Macro Performance Slow When Page Breaks Are Visible

213823 - 2007: Macro That Changes Cell Dimensions on Multiple Sheets Doesnt Run As Expected

213660 - 2007: Not All Worksheet Functions Supported As Methods of Application Object

141693 - 2007: Scope of Variables in Visual Basic for Applications

Knowledge Base Articles - 2003

281953 - 2003: Features turned off when Visual Basic for Applications is not installed

Knowledge Base Articles - 2002

291067 - 2002: 'Out of Memory' Error Running Sub Procedure

213654 - 2002: All PageSetup Settings Are Recorded into Macro

282034 - 2002: Application.Version Does Not Compare Versions as Expected

291206 - 2002: Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High

294859 - 2002: Cannot Record a Macro to Insert a Diagram

293809 - 2002: Changes to the Excel Object Model in Excel 2002

821136 - 2002: DDE Clients Cannot Use a RUN Command to Run an Inline Macro After a Security Update

292482 - 2002: Error Message Method SaveAs of Object _Worksheet Failed

297024 - 2002: Error Message: Document Saved Successfully. Cannot Re-open Saved Document Due to Low Memory

282033 - 2002: Error Message: Run-Time Error 1004: Programmatic Access to the Visual Basic Project Is Not Trusted

331401 - 2002: Excel May Stop Responding If You Call Calculate from an Asynchronous COM Event

134913 - 2002: GetCustomListNum Returns Unexpected List Number

213507 - 2002: How to Count Cells That Contain Formulas Text or Numbers

213343 - 2002: How to Put Folder Contents into a Worksheet

141762 - 2002: How to Use Looping Structures in Visual Basic for Applications

186047 - 2002: Incorrect Formula Using FormulaR1C1 When Chart Active

287104 - 2002: Initialization Error Message When You Cancel the Installation of VBA

074493 - 2002: Macro to Place Filenames in Given Directory on Worksheet

266161 - 2002: Problems When You Use .Formula Property of a Range of Cells to Set Values in an Array

282165 - 2002: Run-time Error 438 When Using NewWindow Method to Return Boolean

293287 - 2002: Unable to Record Macro and No VBA Projects Shown After You Install Office 2000

213634 - 2002: Using Saved Property to Determine If Workbook Has Changed

321286 - 2002: VBA Error on Macro Startup If You Open Multiple Excel Instances with RefEdit Control

Knowledge Base Articles - 2000

211706 - 2000: 'Auto_Open_xlquery_DClick' Error Message When You Open File

213554 - 2000: 'Bad DLL Calling Convention' When Running a Macro

116280 - 2000: 'Cannot Find Macro' Running Macro from Object

213675 - 2000: 'Cannot jump to Application because it is hidden.'

213672 - 2000: 'Cant Execute Code in Break Mode' When Running Macro

213524 - 2000: 'Cant Find Project or Library' When You Run a Macro

228633 - 2000: 'Catastrophic Failure' Error Running Samples.xls Macro

213674 - 2000: 'Compile Error' Running Macro That Changes Margins in Print Preview

213573 - 2000: 'Compile error: Invalid Qualifier' Using 'Checked' 'Gray' and 'Unchecked' in Macros

225059 - 2000: 'Invalid Use of New Keyword' Error Using ADODB Object Library

213682 - 2000: 'Out of Memory' Error Running Sub Procedure

213825 - 2000: 'Overflow' Error Message Running Procedure with Math Calculation

231090 - 2000: 'PasteSpecial method of Range class failed' Error When Running a Macro

211792 - 2000: 'Project Is Unviewable' Error Message When You Try to View Project

213677 - 2000: 'Run-Time Error 4599' Running DDE Macro to Control Excel

234732 - 2000: 'Subscript out of range' Error Programatically Saving Worksheet as Web Page

210757 - 2000: 'Too Many Line Continuations' Error When Recording a Macro

213589 - 2000: 'Type Mismatch' Comparing String Variable to Boolean

212172 - 2000: 'Unable to Record' Message When Recording a Macro

213473 - 2000: A Visual Basic Nested Case Statement Example

264712 - 2000: Access Violation Error Running VBA Code with UserForm SaveCopyAs and Save Functions

213420 - 2000: ActivatePrevious Method Uses Z-Order Defined by User

131290 - 2000: ActivatePrevious Method Uses Z-Order Defined by User

212030 - 2000: Alert for Previous Version Is Displayed by Using the OnSave Property

231106 - 2000: Application.Dialogs(xlDialogChartWizard).Show Fails on PivotChart

213301 - 2000: Application.Interactive Value Not Reset When Macro Stops

213534 - 2000: Application.SendKeys Does Not Wait for Key Processing

213671 - 2000: Arc/Block Arc Adjusted Incorrectly When You Run Macro

215589 - 2000: Assigned Macro Not Copied with Objects

201455 - 2000: Auto List Does Not List CommandText for PivotTable Object

214288 - 2000: AutoSave Command Recorded in Subroutine or Macro

213532 - 2000: Auto_Close Macros Run When You Use Application.Quit

199219 - 2000: Automation Doesnt Release Excel Object from Memory

232332 - 2000: Bidi Excel5 VBA Font Properties Are Not Mapped to New Ones

212160 - 2000: Binder: Virus Warning May Appear More Than Once

232472 - 2000: BottomRightCell VBA Property Returns Bottom-Left Cell Address in Right-to-Left Worksheet

109780 - 2000: Branching to Other Sections of Code with GoTo and Call

213587 - 2000: Cannot Add Macros to the Tools Menu

213435 - 2000: Cannot Display Dialog Box from VBA Macro If Workbook Is Hidden

213551 - 2000: Cannot Import/Export UserForms Between VBA and Visual Basic

213604 - 2000: Cannot Move or Copy Sheet After Last Sheet

213527 - 2000: Cannot Open Add-In Error When Running a Macro

230889 - 2000: Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High

211756 - 2000: Cannot Paste a Picture into a UserForm

213229 - 2000: Cannot Run Macro from Macros Dialog Box

213461 - 2000: Cannot Trap No or Cancel in 'Replace Existing' Dialog Box

213702 - 2000: Cannot Use New Keyword to Create Workbook Object

213809 - 2000: Cannot Use xlConstant Names in Variables in Visual Basic Code

213705 - 2000: Cant Tile Windows with Macro If a Window Is Minimized

213488 - 2000: Cells.Find Returns Error Message When No Match Found

108892 - 2000: Cells.Find Returns Error When No Match Found

211741 - 2000: Clicking Exit Design Mode Switches to Microsoft Excel

213783 - 2000: Compile Error Passing ParamArray

213734 - 2000: Conditional Compilation Code Is Lost When You Save File as an Excel 5.0 File

213786 - 2000: Copying from the Object Browser May Not Copy Named Arguments

235107 - 2000: Crash Running Macro When Object Set to Nothing

200790 - 2000: Crash Saving Workbook If Module Name Contains Equal Sign

213602 - 2000: CreateObject and GetObject Work Differently

213833 - 2000: Creating Macros for Different Language Versions

231144 - 2000: Cut and Paste Operation in Visual Basic Procedure Hangs Excel

213652 - 2000: Default Property/Methods for Objects in Visual Basic

234258 - 2000: Displayed UserForm Does Not Allow Interactivity with Workbook

211626 - 2000: EnableEvents Property Does Not Work in Automation Server

214018 - 2000: Error Message When You Use the Lotus File Combine Command in Macro

211601 - 2000: Error Message: 'Error 2015' or 'Run-time Error 13: Type Mismatch '

211604 - 2000: Error Message: Run-time Error 9: Subscript out of Range

199212 - 2000: Error Opening Workbook That Contains Macro

213830 - 2000: Error Using For Each...Next Statement with OLE Object Type

213556 - 2000: Error When Passing an Array Value Between Macros

265311 - 2000: Excel 95 Auto_xxxx Defined Name Values Change When Imported into Excel 97 or 2000

129795 - 2000: Excel Doesnt Use Containers Name for Embedded Objects

215764 - 2000: Excel4 Macro Runs Slowly When Excel Is in the Background

137807 - 2000: Goto Method Fails When Custom Dialog Box Visible

241399 - 2000: History of Changes to Visual Basic for Applications

272717 - 2000: How To Add the Workbook Path to the Title Bar

113899 - 2000: How To Convert a Database Table into an Excel Spreadsheet

114348 - 2000: How To Print Two Excel Charts on Single Page w/OLE Automation

213288 - 2000: How to Call a Macro Repeatedly on a Fixed Time Interval

147742 - 2000: How to Close All Workbooks but One with Visual Basic Macro

213699 - 2000: How to Convert All Files on a Server to Microsoft Excel

213292 - 2000: How to Copy One of Each Record Type to Another Worksheet

213290 - 2000: How to Create Unique Random Integers Between Two Numbers

213508 - 2000: How to Find Open Programs That Are DDE-Capable

214248 - 2000: How to Force Macro Code to Wait for Outside Procedure

246802 - 2000: How to Get Prime Numbers or Factors

213764 - 2000: How to Programmatically Change the Project Name Property

213264 - 2000: How to Programmatically Convert Column Position Numbers to Column Letters

213352 - 2000: How to Programmatically Create a Chart Without Selecting a Range of Cells

213763 - 2000: How to Programmatically Create a Collection

213529 - 2000: How to Programmatically Create a Reference

213385 - 2000: How to Programmatically Delete Defined Names with Links

213509 - 2000: How to Programmatically Disable Keyboard Functionality

213502 - 2000: How to Programmatically Disable Microsoft Excel Control Menu Commands

213369 - 2000: How to Programmatically Display All Files in a Folder

213268 - 2000: How to Programmatically Find the Nth Word in a Text String

213503 - 2000: How to Programmatically Format Names of Months in All-Capital Letters

213464 - 2000: How to Programmatically Increment a Date With a Spinner

213318 - 2000: How to Programmatically Insert Blank Rows in a Worksheet

213363 - 2000: How to Programmatically Insert Data from a List Box into the Active Cell

213358 - 2000: How to Programmatically Make Sure That Only Numbers Are Entered in a Column

213323 - 2000: How to Programmatically Measure the Visible Range in Points

247507 - 2000: How to Programmatically Modify Hyperlink Addresses on a Worksheet

213730 - 2000: How to Programmatically Perform a Web Query

247933 - 2000: How to Programmatically Reset a Workbook to Default Styles

213416 - 2000: How to Programmatically Save All Open Workbooks

213333 - 2000: How to Programmatically Select the Current Data Area Without Selecting the First Row

213337 - 2000: How to Programmatically Subtract or Sum Two Ranges of Data

213313 - 2000: How to Programmatically Sum Only the Visible Cells in a Range

213387 - 2000: How to Programmatically Suppress an Error Value Returned by a Formula

269613 - 2000: How to Reduce the Chances of Macro Virus Infection

213430 - 2000: How to Run a WordBasic Macro from a Microsoft Excel Macro

213744 - 2000: How to Temporarily Hide a UserForm

213643 - 2000: How to Use Application.Match to Locate Date Values on a Worksheet

213811 - 2000: How to Use DAO to Create a New Microsoft Excel Workbook

139402 - 2000: How to Use DAO to Create a New Microsoft Excel Workbook

213820 - 2000: How to Use Data Access Objects to Join Tables of Different Formats

213619 - 2000: How to Use Dynamic Arrays in a Macro

153307 - 2000: How to call Microsoft Excel macros that take parameters

213740 - 2000: How to record a macro using relative cell references in Excel

213837 - 2000: How to run subroutines and macros from Visual Basic in Excel 2000 or Excel 2002

247311 - 2000: How to use macros to sort data in multiple columns as one column in Excel

213297 - 2000: Increment Relative References by More Than One Cell in VBA

231129 - 2000: Invalid Page Fault When Using Macro to Close Workbook

177991 - 2000: Limitations of Passing Arrays to Excel Using Automation

214002 - 2000: Macro Assigned to a List Box Does Not Run

213785 - 2000: Macro Cannot Open a File That Has No Extension

213662 - 2000: Macro Cannot Scroll Chart Sheet

258427 - 2000: Macro Compatibility with Microsoft Excel

213431 - 2000: Macro Doesnt Function on Multiple Sheets in Group Mode

213696 - 2000: Macro Error Creating Custom Shortcut Menu Item

199953 - 2000: Macro Error Running Recorded Paste Commands

213549 - 2000: Macro Examples Using Option Button Controls on a UserForm

210661 - 2000: Macro Fails to Apply Diagonal Cell Borders

213591 - 2000: Macro Stops Running When Its Workbook Is Closed

201428 - 2000: Macro That Inserts Formula Returns #NAME?

241901 - 2000: Macro Virus Warning Does Not Appear When Opening SYLK File That Contains XLM Code

255605 - 2000: Macro Virus Warning Does Not Appear When You Open a Text File That Contains XLM Code

213664 - 2000: Macro Works Differently on .wk3 Files Than in Microsoft Excel 5.0

213491 - 2000: Macro to Add a Number to a Selected Cell

213642 - 2000: Macro to Append Text from One Text File to Another

213755 - 2000: Macro to Change File Type to 'All Files (*.*)' in Open Dialog Box

213814 - 2000: Macro to Extract Data from a Chart

133198 - 2000: Macro to Import a Text File into Existing Worksheet

106009 - 2000: Macro to Restore Tab Split Box to Default Position

211880 - 2000: Macro to Tile Windows Does Not Work with Minimized Window

213496 - 2000: Macros to Return Windows and System Directory Paths

108278 - 2000: Macros to Return Windows and System Directory Paths

213571 - 2000: No 'Record at Mark' Feature in Microsoft Excel

266156 - 2000: Out of Stack Space Error With Recursive Subroutine and Loop Structure

213520 - 2000: Page Fault Occurs When Running a DDE Macro or Closing Windows

213564 - 2000: ParamArray Must Be Declared as an Array of Variant

213567 - 2000: ParamArrays Are Always Zero-Based

213546 - 2000: Parentheses Around Object May Dereference the Object

199200 - 2000: Private Functions Are Available to Worksheet

263188 - 2000: Q&A About Excel Macro/Laroux Macro Virus

133139 - 2000: Range Command in Macro Selects Cells from Entire Range

213526 - 2000: Recorded Macro Contains DrawingObjects Method

213570 - 2000: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened

211811 - 2000: Run-Time Error Using Macro to Add Custom List

213649 - 2000: Sample Macro Code to Change Case of Text

213617 - 2000: Sample Macro That Wont Allow User to Cancel Dialog Box

245801 - 2000: Sample Macros to Create a Module from an Existing Module Named Range or Text File

213451 - 2000: Sample Visual Basic Procedure to Print Range of Cells

213801 - 2000: Sample Visual Basic code to create a color index table in Excel

213781 - 2000: SaveAs Method for Worksheet Object Doesnt Save Single Ply

258777 - 2000: Some Macros Dont Run After You Upgrade to Excel 2000

213220 - 2000: Summary of Workbook and Worksheet Application Events

213725 - 2000: The Show Method Fails to Pass Arguments

213778 - 2000: Unexpected Behavior for RefEdit Control in Binder

235069 - 2000: Unsigned Macros May Be Trusted When Macro Security Setting Is High

211794 - 2000: Using the MailLogon Method in Microsoft Excel 2000

213523 - 2000: Using the SheetChange Event in Microsoft Excel

180098 - 2000: VBA Macro Behavior Is Different from Excel 5.0 or 7.0

213789 - 2000: Visual Basic Does Not Signal That an Error Has Occurred

213626 - 2000: Visual Basic Examples Using DDE

113237 - 2000: Visual Basic Macro to Concatenate Columns of Data

124935 - 2000: Visual Basic Macros That Add or Remove Hidden Apostrophes

113659 - 2000: Visual Basic Nested Case Statement Example

213395 - 2000: Visual Basic for Applications Procedure to Open or Activate a Workbook

215578 - 2000: Visual Basic for Applications Project Replaced by Unexpected Project

213663 - 2000: Workbook Created with Automation Is Hidden When Opened

294810 - 2000: Workbook_Activate Event Does Not Fire When Driven Programmatically

254733 - 2000: Workbooks Containing User Forms Take Excessively Long Time to Save Across WAN Connections

215697 - 2000: Worksheet Change Events Are Not Activated When You Click Redo

213590 - 2000: Worksheet_Change Does Not Run When Worksheet Sorted

235115 - 2000: Worksheet_Change Event Triggered When You Delete Cells

213353 - 2000: You Receive 'User-Defined Type Not Defined' Error Message When Using Data Access Objects

Knowledge Base Articles - 1997

172043 - 1997: 'Auto_Open_xlquery_DClick' Error Appears Opening File

158905 - 1997: 'Bad DLL Calling Convention' When Running a Macro

172261 - 1997: 'Cannot Quit' After Using Visual Basic Editor

155051 - 1997: 'Cant Enter Break Mode' Stepping Through a Macro

168605 - 1997: 'Compile Error: Ambiguous Name Detected' If a Module Contains Duplicate Subroutine Names

187357 - 1997: 'Compile error: Expected function or variable' with FindFile Method

160457 - 1997: 'Exit Design Mode' Deactivates Visual Basic Editor

157113 - 1997: 'Invalid Use of Null' Error Setting OnRepeat Method

119141 - 1997: 'Macro Error...' with Lotus File Combine Macro

174492 - 1997: 'Method Delete of Object...' Running Sample Code in Help

121213 - 1997: 'Method not Applicable....' When Referring to Excel Objects

159465 - 1997: 'Module Not Found' Error Opening Workbook

173182 - 1997: 'Out of Memory' Error Running Sub Procedure

134826 - 1997: 'Out of Memory' Message Using the OpenText Method

125900 - 1997: 'Overflow' Error Running Procedure with Math Calculation

169374 - 1997: 'Project Is Unviewable' Error Message When You Try to View Project

176265 - 1997: 'Run-time error 4599' Running DDE Macro to Control Excel

157107 - 1997: 'Type Mismatch' Comparing String Variable to Boolean

166492 - 1997: 'Unable to Record' Message When Recording a Macro

178026 - 1997: ALT Key Stuck On After Running Macro with Copy Method

155456 - 1997: ActiveMenuBar.Index Different than Earlier Versions

163270 - 1997: Additional Controls Dialog Box Disappears

156000 - 1997: Additional Controls Dialog May Not Use Long File Names

109205 - 1997: All PageSetup Settings Are Recorded into Macro

160219 - 1997: Application.SendKeys Does Not Wait for Key Processing

158638 - 1997: ApplyNames Method May Cause Invalid Page Fault

177829 - 1997: Arc/Block Arc Adjusted Incorrectly When You Run Macro

121114 - 1997: Array or User Defined Type Expected

120871 - 1997: AutoSave Command Recorded in Subroutine or Macro

160462 - 1997: Auto_Close Macros Run When You Use Application.Quit

157090 - 1997: Background Queries Suspended While Macro Executes

186253 - 1997: Blank Line Inserted into Module

111309 - 1997: Borders Method Applies Inconsistent Format

169107 - 1997: BottomRightCell/TopLeftCell Incorrect with Merged Cell

157653 - 1997: Button Format Carries Over to MS Excel 5 Dialog Sheet

111268 - 1997: Calculating Elapsed Time for a Visual Basic Procedure

157308 - 1997: Calling RunAutoMacros Method More than Once Fails

119882 - 1997: Calling a Microsoft Excel Macro from a Lotus 1-2-3 Macro

121212 - 1997: Canceling OnTime Macro When Time Argument Is Volatile

157203 - 1997: Cannot Add Macros to the Tools Menu

157304 - 1997: Cannot Drag UserForm Control onto a Worksheet

157280 - 1997: Cannot Get OLEObjects Property Referencing Collection

159537 - 1997: Cannot Import/Export UserForms Between VBE and VB4.0

161625 - 1997: Cannot Move Among Unlocked Cells in Scroll Area with TAB

143458 - 1997: Cannot Move or Copy Sheet After Last Sheet

158080 - 1997: Cannot Paste Array Formula in Its Original Cell

170449 - 1997: Cannot Paste Picture into UserForm

159794 - 1997: Cannot Programmatically Close Referenced Workbook

165780 - 1997: Cannot Record External Data Range Properties

160485 - 1997: Cannot Run Macro from Macros Dialog Box

163497 - 1997: Cannot Stop Macro After Switching to Other Program

183021 - 1997: Cannot Use New Keyword to Create Workbook Object

168970 - 1997: Cannot Use New Keyword to Create Workbook Object

163741 - 1997: Cannot Use xlDisplayShapes with DisplayDrawingObjects

140541 - 1997: Cant Add Object to Sheet Protected as UserInterfaceOnly

125765 - 1997: Cant Display Dialog Box from VBA Macro If Workbooks Hidden

131525 - 1997: Cant Run Macro That Calls 16-bit DLL in 32-bit MS Excel

107903 - 1997: Cant Set Value Property in For Each with Variant Type

124107 - 1997: Cant Specify Number of Digits with Fix() or Int()

168436 - 1997: Cant Tile Windows with Macro If a Window Is Minimized

125181 - 1997: Cant Use ActivateMicrosoftApp Method to Activate Excel

140627 - 1997: Cant Use xlConstant Names in Variables in VB Code

108351 - 1997: ChDir May Fail When Changing to a Root Directory

290640 - 1997: Change Event Is Not Triggered When You Delete Rows or Columns

157347 - 1997: Change in ADD.MENU Macro Position Argument

161609 - 1997: Changes to Microsoft Visual Basic for Applications

157758 - 1997: Clicking Cancel Button May Not Dismiss UserForm

170703 - 1997: Clicking Exit Design Mode Switches to Microsoft Excel

158688 - 1997: Closing UserForm Causes MS Excel to Hang

157346 - 1997: Code 'Behind' Worksheet or Workbook may not Work

157202 - 1997: Color Palette Looks Different in Microsoft Excel 97

157351 - 1997: Compile Error Passing ParamArray

161959 - 1997: Conditional Compilation Code Lost With 5.0/95 Format

124887 - 1997: Control Block Statement Error Messages

130044 - 1997: Controlling Appearance of Mouse Pointer Within Macro

184000 - 1997: Controlling Events in an Automation Server

111899 - 1997: Controls in Dialog Box May 'Snap' to Preset Values

157315 - 1997: Copy From Object Browser May Not Copy Named Arguments

131385 - 1997: CopyFromRecordset Method Does Not Return Field Headings

159877 - 1997: Crash Saving Workbook If Module Name Contains Equal Sign

177393 - 1997: Crash Saving Workbook That Uses BeforeSave Event

143461 - 1997: CreateObject and GetObject Work Differently

111388 - 1997: Creating Macros for Different Language Versions

130557 - 1997: Creating a Linked Directory List Box

157436 - 1997: DAO 3.0 CopyFromRecordset Method Not Compatible with Excel 97

161836 - 1997: Deactivate Event Doesnt Occur After Moving Sheet

114857 - 1997: Default Property/Methods for Objects in Visual Basic

118468 - 1997: Definition of DoEvents in Visual Basic for Applications

232094 - 1997: Deleting a Cell Changes the UsedRange Property

108002 - 1997: Determining Which DLLs Are Registered

111564 - 1997: Determining Which Items Are Selected in a List Box

131237 - 1997: Dialog Box Show Method Fails with Reference Type Edit Box

117412 - 1997: Dialog Constants That Do Not Have an Interactive Dialog

125805 - 1997: Displaying Several Dialog Boxes Without Looping

108350 - 1997: Distinguishing Sheet Types with Visual Basic Macro

164920 - 1997: DocErr: vbMsgBoxHelpButton Not Listed in Help

158639 - 1997: Edit Box Does Not Appear in Toolbox

107716 - 1997: Edit Code Fails When Object Formula Passes Parameters

171716 - 1997: Embedded Worksheet Object Stops After Running Macro

172499 - 1997: Error Appears When CopyFromRecordSet Uses Empty Variable

160058 - 1997: Error Changing Order of Option Buttons on a Dialog Sheet

129252 - 1997: Error Creating OLE Automation Object with Microsoft Excel

108517 - 1997: Error Getting the Value of a Name in Visual Basic

169100 - 1997: Error Message Running Recorded Macro That Resizes a Line

193650 - 1997: Error Message: Invalid Data Format

156882 - 1997: Error Message: Name Conflicts with Existing Module

157407 - 1997: Error Passing Objects to Subroutine

117363 - 1997: Error Running Inserted Text File Macro from Another Macro

166933 - 1997: Error Running Macro That Inserts Control into UserForm

167990 - 1997: Error Running Macro to Modify Shape Text

170740 - 1997: Error Running SQLRetrieve with Embedded Chart

161324 - 1997: Error Using 'Mailto:' with FollowHyperlink Method

176783 - 1997: Error Using DDEPoke When Chart Is the Active Sheet

161477 - 1997: Error Using RemoveItem Method

126094 - 1997: Error Using XLCALL and SaveAs Functions

158353 - 1997: Error When Invalid Characters in Drawing Object Name

108507 - 1997: Error When Macro Closes Its Own Workbook

158746 - 1997: Error When Passing an Array Value Between Macros

158997 - 1997: Error When Variable Refers to Deleted or Moved Sheet

107469 - 1997: Error in Procedure Causes 'Cannot Find Procedure'

174226 - 1997: Errors Using Quit Method with Virus Search Add-in Loaded

143452 - 1997: Excel Hangs When You Programmatically Save a Workbook

107980 - 1997: Excels =REQUEST() from DDEML Application Returns #N/A

166338 - 1997: Export Method Code Example in Help Is Incorrect

157101 - 1997: F1 in Custom XLM Dialog Box Displays Office Assistant

111725 - 1997: FOR Behaves Differently in Visual Basic than in XLM Macro

166092 - 1997: File Size Increases After Launching Visual Basic Editor

158083 - 1997: FindPrevious Method Does Not Support Discontiguous Range

125179 - 1997: Finding Graphic Objects Within a Range with TopLeftCell

102362 - 1997: Finding Open Applications That Are DDE Capable

134410 - 1997: FitToPagesWide or FitToPagesTall Doesnt Affect PageSetup

172588 - 1997: Format Function May Return an Incorrect Date

105571 - 1997: Function Name Cant be Same as Module Name

119570 - 1997: GP Fault/Error Using For Each Statement with OLE Object Type

184590 - 1997: General ODBC Error Running Macro from Excel for Macintosh

161512 - 1997: GetSaveAsFilename Method Returns Extra Character

159489 - 1997: Grouping ActiveX Option Buttons on a Worksheet

164500 - 1997: Help Argument for MsgBox Function Behaves Differently

111392 - 1997: Hiding Button Objects with Visual Basic for Applications

157416 - 1997: How to Assign a Macro to an ActiveX Worksheet Control

129153 - 1997: How to Avoid 'Save Changes?' When You Close a Workbook

139403 - 1997: How to Change Arabic Page Numbers to Roman Numerals

142531 - 1997: How to Check Spelling for Worksheet Objects Only

141513 - 1997: How to Continue a Visual Basic Statement from One Line to the Next

141770 - 1997: How to Control the AutoFilter with a Macro

158244 - 1997: How to Create Application Level Event Handlers

142142 - 1997: How to Create Yes and No Buttons for a Custom Message Box

141574 - 1997: How to Create a Macro That Opens Multiple Selected Files

158848 - 1997: How to Create a Startup Screen with a UserForm

160473 - 1997: How to Create a Template for a Toolbox Control

141563 - 1997: How to Create and Use an Auto_Close Procedure

159915 - 1997: How to Delete Cells with a For Each...Next Loop

125423 - 1997: How to Delete and Restore a Menu That Has a Submenu

139405 - 1997: How to Determine How Many Pages Will Be Printed

161903 - 1997: How to Determine the Key Pressed Along with Mouse Button

157609 - 1997: How to Display a UserForm Whose Name Is in a Variable

139723 - 1997: How to Display the Open and Save As Dialog Boxes

160589 - 1997: How to Dynamically Resize a User Form

124213 - 1997: How to Enter a Second Line in a Message Box

142530 - 1997: How to Hide Sheets and Use xlVeryHidden Constant in a Macro

162944 - 1997: How to Modify the Number of Undo Levels

161521 - 1997: How to Move Between Custom UserForms with CommandButtons

063091 - 1997: How to Open a Document Linked to Password-Protected Sheet

161518 - 1997: How to Populate One ListBox Based On Another ListBox

161214 - 1997: How to Programmatically Change the Project Name Property

161215 - 1997: How to Programmatically Create a Collection

160647 - 1997: How to Programmatically Create a Reference

107689 - 1997: How to Programmatically Disable Microsoft Excel Control Menu Commands

247980 - 1997: How to Programmatically Reset a Workbook to Default Styles

162049 - 1997: How to Remove Individual AutoFilter Drop-Down Lists

142154 - 1997: How to Run a Macro When Certain Cells Change

128405 - 1997: How to Run a WordBasic Macro from an MS Excel Macro

141578 - 1997: How to Show Quotation Marks in Function Results and Macros

161535 - 1997: How to Simulate a Paused Visual Basic Procedure

161536 - 1997: How to Temporarily Hide a UserForm

165867 - 1997: How to Use EnableEvents to Disable Event Handling

155837 - 1997: How to Use FileSearch to Fill a Listbox with File Names

142141 - 1997: How to Use Input Boxes with Visual Basic for Applications

142119 - 1997: How to Use a Macro to Enter Cell Note Text in a Text Box

161514 - 1997: How to Use a UserForm for Entering Data

161930 - 1997: How to Use the GetOpenFilename Method

161326 - 1997: How to Verify the Value of a CheckBox on a UserForm

159997 - 1997: Illegal Operation Closing File When VBE Is Visible

159947 - 1997: Illegal Operation Unhiding a Row with a Macro

159336 - 1997: Illegal Operation Using Unload with Enter Event

221568 - 1997: Implicitly Setting Value of Range Object Crashes Excel

159338 - 1997: Imported Toolbox Page Loses Caption and Tip Text

157232 - 1997: Incorrect Definitions Displayed in Object Browser

193727 - 1997: Incorrect Workbook Saved from Visual Basic Editor

159874 - 1997: Indexes for Methods and Collections Are Rounded

112030 - 1997: Infinite Loop If OLE Automation Server Busy

158659 - 1997: Insert and Delete Methods of Characters Class May Fail

166093 - 1997: Invalid Page Fault Using DropDown Method with ComboBox

157306 - 1997: Len Function Returns Only 1024 Characters in Cell

168841 - 1997: Letters Available as Keyboard Shortcuts for Macros

158632 - 1997: Limitations for Naming Visual Basic Modules

166932 - 1997: List Box Doesnt Work Correctly When Workbook Is Hidden

077751 - 1997: Lotus Macros That Do Not Directly Translate into Excel

157127 - 1997: MS Excel Hangs with UserForm Displayed in Binder

124330 - 1997: Macro Assigned to List Box Fails

157320 - 1997: Macro Cannot Open a File That Has No Extension

106004 - 1997: Macro Cannot Scroll Chart Sheet

138621 - 1997: Macro Code to Check Whether a File Is Already Open

170448 - 1997: Macro Command Menubars(xlWorkBook) Is Not Valid

269178 - 1997: Macro Compatibility with Microsoft Excel

126313 - 1997: Macro Doesnt Function on Multiple Sheets in Group Mode

157158 - 1997: Macro Doesnt Recognize OLEObject Name Property

159858 - 1997: Macro Error Accessing OLEObject on Worksheet

171025 - 1997: Macro Error Creating Custom Shortcut Menu Item

157316 - 1997: Macro Error Using ActiveCell in a Binder or Embedded File

115209 - 1997: Macro Error Using GET.DEF Function to Return Local Name

166143 - 1997: Macro Error Using Show Method with AutoShape Selected

171309 - 1997: Macro Error When You Use GET.TOOLBAR Command

138823 - 1997: Macro Example to Return Item from Worksheet Control

159705 - 1997: Macro Examples Using OptionButton Controls on a UserForm

145598 - 1997: Macro Performance Slow When Page Breaks Are Visible

159223 - 1997: Macro Recorder Doesnt Record Some Menu Commands

157103 - 1997: Macro Stops Running When its Workbook Is Closed

131164 - 1997: Macro That Changes Cell Dimensions on Multiple Sheets Fails

199301 - 1997: Macro That Inserts Formula Returns #NAME?

199972 - 1997: Macro Virus Warning Appears Opening File Without Macro

171661 - 1997: Macro Virus Warning Appears Opening File Without Macros

241902 - 1997: Macro Virus Warning Does Not Appear When Opening SYLK File That Contains XLM Code

255606 - 1997: Macro Virus Warning Does Not Appear When You Open a Text File That Contains XLM Code

108642 - 1997: Macro to Add a Number to a Selected Cell

161486 - 1997: Macro to Change File Type to 'All Files (*.*)' in Open Dialog Box

161607 - 1997: Macro to Change the Date/Time Format in a Header/Footer

118589 - 1997: Macro to Check for Page Breaks on Worksheet

153318 - 1997: Macro to Convert Column Numbers to Column Letters

159493 - 1997: Macro to Create Data Validation Circles for Printing

138619 - 1997: Macro to Delete Defined Names with Links

110754 - 1997: Macro to Determine If Excel Is Open for In-Place Editing

137016 - 1997: Macro to Extract Data from a Chart

140034 - 1997: Macro to Insert Data from a List Box into the Active Cell

125890 - 1997: Macro to Insert an Object at the Active Cell

139724 - 1997: Macro to Loop Through All Files in a Folder (Directory)

161393 - 1997: Macro to Open the Most Recently Used File

117225 - 1997: Macro to Print All Embedded Charts on a Worksheet

107880 - 1997: Macro to Print a Group of Files Located in Same Folder

104997 - 1997: Macro to Save Data as Tab-Delimited File without Quotes

142122 - 1997: Macro to Search for Cell Formats: Font Border and Interior

089949 - 1997: Macro to Select all Data on a Worksheet

138080 - 1997: Macro to Suppress an Error Value Returned by a Formula

166450 - 1997: Macro to Tile Windows Does Not Work with Minimized Window

125810 - 1997: Macro with OnEntry or ON.ENTRY() Not Activated

143466 - 1997: Macro97.exe File Available on Online Services

132509 - 1997: Macros to Alter Workspace Based on Active File

126093 - 1997: Macros to Delete Formula Links

101567 - 1997: Macros to Disable Keyboard Input

172515 - 1997: Making the Active Row Bold Using SelectionChange Event

108799 - 1997: Manually Recalculating a Single Cell or Range

160489 - 1997: Menu Editor and Make Add-In Dialog Boxes Cause Error

162549 - 1997: Microsoft Excel Toolbars Appear in the Visual Basic Editor

161816 - 1997: Min Can Exceed Max on ScrollBar or SpinButton Control

165304 - 1997: Modules Inserted Manually Are Not in Modules Collection

174201 - 1997: Names Collection Result Is Incorrect or Returns an Error

163263 - 1997: New UsedRange Property Behavior

156442 - 1997: No 'Center Across Columns' Toolbar Button

157958 - 1997: No 'Record at Mark' Feature in Microsoft Excel

158472 - 1997: No Automatic Type Coercion Between Variable Types

158749 - 1997: No Data Validation Property for UserForm TextBoxes

105202 - 1997: No Direct Visual Basic Equivalent for SOUND.PLAY()