Query98: Query Returns More Records Than You Specify

XL98 Err Msg: 'Name Conflicts with Existing Module'

XL98: Errors Saving When Transition Formula Evaluation Enabled

XL98: '

XL98: '255 Characters in Cell' Error When Copying Worksheet

XL98: 'am/pm' Changed to 'AM/PM' in Custom Number Format

XL98: 'Cannot Quit' After Using Visual Basic Editor

XL98: 'Cannot Shift Objects Off Sheet' Error Hiding Columns

XL98: 'Create Hyperlink Here' Does Not Work in Unsaved File

XL98: 'Data Truncated' Error Connecting to SQL Server 7.0

XL98: 'Disk Is Full' Error Saving Workbook

XL98: 'Document Not Saved' Saving File Created from Template

XL98: 'Error in loading DLL' Opening Workbook with Macros

XL98: 'File Format Not Valid' Error Opening Routed Workbook

XL98: 'Insert Copied Cells' Menu Item Missing After Copy

XL98: 'INTERSOLV' Error Refreshing or Editing Saved Query

XL98: 'Invalid Picture' When Setting Picture Property

XL98: 'Invalid Use of Null' Error Setting OnRepeat Method

XL98: 'MS Query Not Installed' Error When Starting MS Query

XL98: 'Not Enough Memory' Error Adding Chart to Workbook

XL98: 'Not Enough Memory' Error Messages Repeatedly Appear

XL98: 'Not Enough Memory' Error Opening File from Excel 5.0

XL98: 'Not Enough Memory' Error Opening Workbook with PivotTable

XL98: 'PivotTable Is Not Valid' Error Working with PivotTable

XL98: 'Set Language' Add-In Specifies Language for Proofing

XL98: 'System Error H80000003 ...' Renaming TabStrip Tab

XL98: 'Type Mismatch' Comparing String Variable to Boolean

XL98: 'Unable to Read File' Error Opening Workbook

XL98: #REF! Error Recalculating Worksheet with Defined Name

XL98: #VALUE! Appears When Function Is Recalculated

XL98: 3-D Surface Chart Lines May Not Follow Slope of Data

XL98: Active Cell Moves Using RefreshTable Method

XL98: ActiveMenuBar.Index Is Different from Earlier Versions

XL98: Application Error Type 2 Assigning Macro to Custom Menu

XL98: ATP Error: 'Cannot Add Chart to a Shared Workbook'

XL98: ATP Functions Unexpectedly Return #NAME Error Value

XL98: Attached Toolbar Is Not Saved in 5.0/95 File Format

XL98: Auto_Close Macros Run When You Use Application.Quit

XL98: AutoCorrect Stops After 255 Characters

XL98: Balloon Help Is Not Available for Some Controls

XL98: Bitmap Image Shrinks When Pasted on a Toolbar Button

XL98: Borders Appear in Printout When You Use Track Changes

XL98: Borders Printed Black with 'Black and White' Selected

XL98: BottomRightCell/TopLeftCell Incorrect with Merged Cell

XL98: Bypassing the Text Import Wizard When You Import Files

XL98: Calling RunAutoMacros Method More than Once Fails

XL98: Can Change Protected Document's Properties with VB Macro

XL98: Can't Link Value of Control to Function

XL98: Cannot Add Macros to the Tools Menu

XL98: Cannot Change Fill Color for Walls or Floor on 3-D Chart

XL98: Cannot Change Value for Form Control on a Worksheet

XL98: Cannot Drag Page Breaks in Page Break Preview

XL98: Cannot Make Changes to Some Shortcut Menus

XL98: Cannot Modify Microsoft Excel 5.0 Add-in

XL98: Cannot Move Among Unlocked Cells in Scroll Area with TAB

XL98: Cannot Move or Copy Sheet After Last Sheet

XL98: Cannot Open Files from HTTP or FTP Web Servers

XL98: Cannot Paste Array Formula in Its Original Cell

XL98: Cannot Paste Picture into UserForm

XL98: Cannot Reset a Column to the Standard Width

XL98: Cannot Save Document After Losing Network Connection

XL98: Cannot Save to Floppy Disk or Network Disk Drive

XL98: Cannot Select Desktop as Folder to Search for Laroux Virus

XL98: Cannot Select Worksheet After Macro has Completed

XL98: Cannot Use Array of Data Points with Extend Method

XL98: Cannot Use Custom Function with Data Validation

XL98: Cannot Use Keyboard to Select Items in Special List

XL98: Cannot Use New Keyword to Create Workbook Object

XL98: Cannot Use Page Setup Property If No Printers Installed

XL98: Cells Adjacent to Print Area Are Printed

XL98: Certain Functions Calculate Differently in Early Versions

XL98: Changes to Microsoft Visual Basic for Applications

XL98: Chart Activation with Macro Changes Selection

XL98: Chart Format Dialog Not Displayed Properly Under MacOS 9

XL98: Charts.Delete Command in Macro May Delete Worksheets

XL98: Clicking 'Import From FileMaker' Causes Excel to Quit

XL98: Clicking Cancel Button May Not Dismiss UserForm

XL98: Clicking Zoom Button Hides Contents of Worksheet

XL98: Closing Workbook with VBA Appears to Stop the Macro

XL98: Code 'Behind' Worksheet or Workbook may not Work

XL98: Color Palette Looks Different in Microsoft Excel 98

XL98: Command Underlines Not Available in Some Dialog Boxes

XL98: Comment Formatting May Be Lost When You Share a Workbook

XL98: Comments Are Resized Unexpectedly

XL98: Compile Error Running Recorded Macro That Uses Solver

XL98: Conditional Compilation Code Lost With 5.0/95 Format

XL98: CONTROL+OPTION+TAB Does Not Insert Tab into Active Cell

XL98: Copy from Object Browser May Not Copy Named Arguments

XL98: Crash Saving Workbook That Uses BeforeSave Event

XL98: Custom Function Is Not Recalculated with Intersection

XL98: Custom Function May Not Calculate Expected Value

XL98: Custom Menu Merges with Custom Toolbar

XL98: Custom Toolbar Added Above Existing Toolbars

XL98: DAO and ODBCDirect Are Not Supported

XL98: Data Imported from FileMaker Pro Is Not Sorted Correctly

XL98: Data Returned to Wrong Row Using SQLBind

XL98: Data Validation List Does Not Appear

XL98: Data Validation Message May Not Disappear

XL98: Date Returned in a Macro Is Four Years Too Early

XL98: Days of the Week Before March 1, 1900, Are Incorrect

XL98: Deactivate Event Doesn't Occur After Moving Sheet

XL98: Default Property/Methods for Objects in Visual Basic

XL98: Defined Names Are Case Sensitive in Microsoft Excel 98

XL98: Deleting Cells with a For Each...Next Loop

XL98: Description of the Value2 Property for the Range

XL98: Determining Which Items Are Selected in a List Box

XL98: Dialog Box Show Method Fails with Reference Type Edit Box

XL98: Dialog Constants That Do Not Have an Interactive Dialog

XL98: Displaying a UserForm with a Name That Is in a Variable

XL98: Double-Clicking Query File Does Not Open File

XL98: Drawing Objects Behave Differently When Clicked

XL98: Embedded Worksheet Object Stops After Running Macro

XL98: Error Adding or Deleting a Menu Command in a Macro

XL98: Error Appears When You Change List Property of Combo Box

XL98: Error Applying Comment When Worksheets Are Grouped

XL98: Error Creating Web Page with Option Base 1 Setting

XL98: Error Gathering List of Tables for FileMaker Pro Data

XL98: Error Messages Closing WK4 File

XL98: Error Running Inserted Text File Macro from Another Macro

XL98: Error Running Macro That Inserts Control into UserForm

XL98: Error Running Macro That Recorded Data Analysis Tools

XL98: Error Running Macro to Modify Cell Comments

XL98: Error Running Macro to Modify Shape Text

XL98: Error Saving File to Path Longer Than 254 Characters

XL98: Error Setting AxisGroup Property of Series Class

XL98: Error Using GetObject to Activate Running Instance of Word

XL98: Error Using Natural Language Formula in a Macro

XL98: Error Using RemoveItem Method

XL98: Error Using XLCALL and SaveAs Functions

XL98: Error When Passing an Array Value Between Macros

XL98: Error When Pasting ActiveX Controls or Running a Macro

XL98: Error with Invalid Characters in Drawing Object Name

XL98: Euro Symbol Not Available in Currency Symbol List

XL98: Excel Crashes When Adding Third Conditonal Formatting Rule

XL98: Excel Documents May Not Show in Recent Documents List

XL98: Excel Quits Unexpectedly Running Macro That Creates Chart

XL98: Excel Quits When You Add Shadow to Series in Surface Chart

XL98: Excel Quits When You Save a Workbook with a Module

XL98: Excel Stops Responding While Running Virus Search

XL98: FileMaker Wizard Imports Data into the Wrong Worksheet

XL98: FindPrevious Method Does Not Support Nonadjacent Cells

XL98: Format Function May Return an Incorrect Date

XL98: Formula Returns Incorrect Value When Changed by a Macro

XL98: Formulas Not Recalculated with Data Table in Workbook

XL98: Function to Convert Degree to/from Fractions of Degrees

XL98: GetSaveAsFileName Method Arguments Are Ignored

XL98: Hard Disk Name Appears in Formula or Defined Name

XL98: How to a Fill ListBox Control with Multiple Ranges

XL98: How to Add Data to a ComboBox or a ListBox

XL98: How to Change the Font in a Cell Comment

XL98: How to Change the Taper Style for All Series in a Chart

XL98: How to Close All Workbooks but One with Visual Basic Macro

XL98: How to Completely Remove Data Access

XL98: How to Convert an Add-in File into a Workbook

XL98: How to Convert Files to Excel 98 Format

XL98: How to Create a Chart with Discontiguous Ranges

XL98: How to Create a Dynamic Chart by Using Visual Basic

XL98: How to Create a Dynamic Named Range

XL98: How to Create a Group of Mutually Exclusive ToggleButtons

XL98: How to Create a Startup Screen with a UserForm

XL98: How to Create a Template in MS Excel 98

XL98: How to Create and Use a Workbook_BeforeClose Procedure

XL98: How to Create Parameter Queries

XL98: How to Create PivotTable from Word

XL98: How to Create Web Query Files

XL98: How to Customize a Custom Toolbar Button

XL98: How to Delete a Sub Procedure After It Runs Once

XL98: How to Determine if the Active Cell Contains a Comment

XL98: How to Disable Shortcut Menus

XL98: How to Display Custom Function in Function Wizard Step 2

XL98: How to Display Top 10 Records with a Macro

XL98: How to Dynamically Resize a User Form

XL98: How to Identify and Remove the PLDT Macro Virus

XL98: How to Move Between Custom UserForms with CommandButtons

XL98: How to Obtain and Install the Excel 98 Y2K Update

XL98: How to Pass a Cell Value to an AppleScript Variable

XL98: How to Populate One ListBox Based on Another ListBox

XL98: How to Programmatically Change the Project Name

XL98: How to Programmatically Create a Collection

XL98: How to Programmatically Create a Reference

XL98: How to Programmatically Perform a Web Query

XL98: How to Programmatically Save a Worksheet as HTML

XL98: How to Record a Macro That Uses Relative Cell References

XL98: How to Remove All Items from a ListBox or ComboBox

XL98: How to Restore a Built-In Menu

XL98: How to Run VBA Procedures from AppleScript

XL98: How to Scroll Window Views from Object to Object

XL98: How to Simulate a Paused Visual Basic Procedure

XL98: How to Specify Dynamic Web Query Parameters

XL98: How to Trap Events for an Embedded Chart

XL98: How to Use 'On Error' to Handle Errors in a Macro

XL98: How to Use a Toolbar Button to Open a File Indirectly

XL98: How to Use a UserForm for Entering Data

XL98: How to Use EnableEvents to Disable Event Handling

XL98: How to Use Grouping for Fields in a PivotTable

XL98: How to Use the ApplyCustomType Method to Format Charts

XL98: How to Use the Histogram Add-In

XL98: How to Use the Template Wizard with Data Tracking Add-In

XL98: How to Use the TextColumn Property

XL98: How to Use the Virus Search Add-in for Microsoft Excel 98

XL98: How to Use Wildcards in Parameter Queries

XL98: How to Verify the Value of a CheckBox on a UserForm

XL98: HTTP or FTP Path to Workbook Is Unchanged After Save As

XL98: Hyperlink Created by HYPERLINK Function Is Not Preserved

XL98: Hyperlinks May Be Corrupted When Modified by a Macro

XL98: Inconsistent Results Using Natural Language Formulas

XL98: Incorrect Formula Using FormulaR1C1 When Chart Active

XL98: Indexes for Methods and Collections Are Rounded

XL98: Insert and Delete Methods of Characters Class May Fail

XL98: Inserting Rows or Columns Slower with Page Breaks Visible

XL98: IsDate Function Incorrectly Identifies Some Expressions

XL98: LastUpdated Argument of Htmlconvert Is Not Functional

XL98: Len Function Returns Only 255 Characters in Cell

XL98: Limitations for Naming Visual Basic Modules

XL98: Limits of PivotTables in Microsoft Excel 98

XL98: Links to Excel 4.0 Macro Sheets Do Not Update

XL98: List of Errors That Formula AutoCorrect Detects

XL98: ListBox Control Is Resized If Column Width Is Set to Zero

XL98: Lookup Wizard May Cause Errors

XL98: Macro Cannot Scroll Chart Sheet

XL98: Macro Doesn't Function on Multiple Sheets in Group Mode

XL98: Macro Error Message Appears Behind MS Excel 5.0 Dialog

XL98: Macro Examples Using OptionButton Controls on a User Form

XL98: Macro Recorder Doesn't Record Some Menu Commands

XL98: Macro Stops Running When its Workbook Is Closed

XL98: Macro That Changes Cell Dimensions on Multiple Sheets Fail

XL98: Macro to Append Text from One Text File to Another

XL98: Macro to Change the Date/Time Format in a Header/Footer

XL98: Macro to Create Data Validation Circles for Printing

XL98: Macro to Delete Defined Names with Links

XL98: Macro to Insert a Blank Row on Every Other Row of Sheet

XL98: Macro to Insert an Object at the Active Cell

XL98: Macro to Loop Through Range and Act Based on Cell Value

XL98: Macro to Open the Most Recently Used File

XL98: Macro to Save the Personal Macro Workbook Without Prompt

XL98: Macro Virus Warning Appears Opening File Without Macro

XL98: Making the Active Row Bold Using SelectionChange Event

XL98: Menu Bars and Toolbars Flash When You Close a Workbook

XL98: Menu Editor and Make Add-in Dialog Boxes Cause Error

XL98: Message Box Function Has a Title Bar

XL98: Min Can Exceed Max on Scroll Bar or SpinButton Control

XL98: MOD Function and Mod Operator Return Different Values

XL98: Modules Inserted Manually Are Not in Modules Collection

XL98: MS Excel 5.0 Dialog Sheet Closes When Control Is Clicked

XL98: New UsedRange Property Behavior

XL98: NewSheet Event Not Triggered When Inserting a Worksheet

XL98: No 'Record at Mark' Feature in Microsoft Excel

XL98: No Automatic Type Coercion Between Variable Types

XL98: No Menu Choice to Select All Hyperlinks

XL98: No Trappable Events for Dialog Sheets and Macro Sheets

XL98: Number Signs (###) Displayed in Cells of a Worksheet

XL98: Object Is Not Visible After Using CreateObject Method

XL98: OK Button in Message Box Is Right-Aligned or Centered

XL98: OnData Property Doesn't Work With Object Links

XL98: Only 'About Balloon Help' Is Displayed When Clicking Help

XL98: Only 1,024 Characters Are Displayed in a Cell

XL98: Only One Custom Chart Type Is Available in Chart Wizard

XL98: OnSave Property Doesn't Run Using Save As Command

XL98: OnSave Property Is Not Available in Object Browser

XL98: Open Event Macro May Not Activate a Worksheet

XL98: Options Not Available in Macro Options Dialog Box

XL98: Options on GetSaveAsFilename Dialog Box Not Returned

XL98: Overflow Error Occurs When Using Err Object

XL98: Overview of ODBC Add-in Functions and Arguments

XL98: Overview of the Built-In Chart Types

XL98: ParamArray Must Be Declared as an Array of Variant

XL98: ParamArrays Are Always Zero-Based

XL98: Preventing UserForm from Being Dismissed with Close Button

XL98: Problems Disabling and Enabling Shortcut Menus

XL98: Problems If Virtual Memory Off or Available Memory Low

XL98: Problems Using ColorIndex to Set Color of Borders

XL98: Problems When Disabling/Enabling Menus

XL98: Problems When Removing Line from Drawing Object

XL98: Problems When Selecting Error Bars with a Macro

XL98: Problems with Arguments of PasteSpecial Method

XL98: Procedure to Open or Activate a Workbook

XL98: Products That Qualify for the MS Excel 98 Upgrade

XL98: Program Stops Responding Moving Chart Location Using Macro

XL98: Protect Method Password Is Not Applied to Worksheet

XL98: Protected Worksheet Allows You to Paste Data into Cells

XL98: Public Variables Not Seen on Modules for Sheet or UserForm

XL98: Range Command in Macro Selects Cells from Entire Range

XL98: Range.PasteSpecial Changes Selection

XL98: RefEdit Control Still Appears After You Close UserForm

XL98: Returning Values from a Multi-Column ListBox

XL98: RGB Function May Map to Incorrect Color

XL98: Run-Time Error '1004' Using CustomViews Collection

XL98: Run-Time Error 57121 If Macro Uses ControlFormat Object

XL98: Run-time Error Evaluating Immediate Window Expression

XL98: Run-time Error Setting MaxChange Property

XL98: Run-time Error Using For Each Loop with OLE Object Type

XL98: Run-Time Error Using Macro to Add Custom List

XL98: Run-Time Error Using SpecialCells Method with Protection

XL98: Run-Time Error When Using DDEInitiate with Word

XL98: Run-Time Errors Running Macro Created in Non-English Excel

XL98: Run-Time Errors Using UserForms Collection

XL98: Sample Macro to Remove User Name from Comment

XL98: Sample Macro to Retrieve Defined Name of the ActiveCell

XL98: Sample Visual Basic Procedure to Print Range of Cells

XL98: Select Method May Select More Cells Than You Expect

XL98: Setting RowSource Property Results in Run-Time Error

XL98: Setting the Default CommandButton on a UserForm

XL98: Setting WindowState Property Generates the Wrong Error

XL98: Shared Files May Open as Read Only

XL98: Show Method Fails with Passed Arguments

XL98: Some On Events Are Not Displayed in Object Browser

XL98: Some Page Breaks May Not Be Removed in Group Edit Mode

XL98: Status Bar Text Not Displayed When You Point to Toolbar

XL98: Stop Recording Button Is Not Displayed Recording a Macro

XL98: Structure and Windows Arguments of Protect Method

XL98: Styles('X').Parent Different Than in Earlier Versions

XL98: SUBTOTAL May Include Data in Hidden Rows

XL98: Summary of Workbook and Worksheet Application Events

XL98: Syntax Error Running Macro That Inserts WordArt

XL98: System Error Using DropDown Method with ComboBox

XL98: TabStrip Information Missing from Value Property Help

XL98: Text Clipping Cannot Be Dragged into Active Text Box

XL98: Text Contained in AutoShapes Does Not Rotate

XL98: Text Is Truncated in a Text Box with Rounded Corners

XL98: Text Property Is Limited to 255 Characters

XL98: TextColumn Property Displays Only the First Column

XL98: Tools Menu Missing Spelling After Loading Analysis ToolPak

XL98: Troubleshooting Problems with Oracle 3.01 ODBC Driver

XL98: Type 2 Error Adding User-Defined Chart Type

XL98: Type 2 Error Message Saving a Workbook or Add-In

XL98: Type 2 Error Running Macro That Adds Chart to Worksheet

XL98: Type 3 Error Creating Data Source

XL98: Type Mismatch: Array or User Defined Type Expected

XL98: Unable to Close File Activated by WorkbookBeforeClose

XL98: Unable to Open File After Changing Code Name of Sheet

XL98: Unable to Rotate AutoShapes While in Edit Mode

XL98: Unable to Use File URL in Linking Formulas

XL98: Unexpected Font or Color Formatting Applied to Chart

XL98: Unexpected Results Paste Linking Nonadjacent Range

XL98: Unexpected Results Using the SolverAdd Function

XL98: UserControl Property Code Example Doesn't Work

XL98: UserForm May Not Be Closed Using QueryClose Event

XL98: Using a Date Range in the Holidays Argument of Networkdays

XL98: Using File and User Data Sources in Microsoft Query

XL98: Using NoteText and Comment.Text to Apply Comments

XL98: Using Saved Property to Determine If Workbook Has Changed

XL98: Using the LoadPicture Function with an Image Control

XL98: Using the MenuBars Method in Microsoft Excel 98

XL98: Using the New Keyword to Create Instances of a UserForm

XL98: Using the RefEdit Control with a UserForm

XL98: Using VbConstants in Text Strings in MS Excel 98

XL98: Using Visual Basic to Create a Chart Using a Dynamic Range

XL98: Value Property Unchanged in For Each Loop w/ Variant Type

XL98: Variant Array of Dates Is Transferred to Worksheet

XL98: Varied Results with Mixed Text

XL98: VBA Macro Behavior Is Different from Excel 5.0

XL98: VBA Macro to Protect Multiple Sheets in a Workbook

XL98: Visual Basic Example for Using SpinButton with a Date

XL98: Visual Basic Macro to Break Chart Links

XL98: Visual Basic Macros That Add or Remove Hidden Apostrophes

XL98: Warning Appears When You Use GetObject to Open Workbook

XL98: Workbook Created via Automation Opens as Hidden

XL98: Workbook File Size Increases While Editing Procedure

XL98: Worksheet Change Event Error Using Names Property

XL98: Worksheet Change Event Macro Fails to Run

XL98: Worksheet Events Don't Occur After Clicking Link

XL98: Worksheet Menu Bar May Not Appear As Expected

XL98: Worksheet_Change Does Not Run When Worksheet Is Sorted

XL98: Wristwatch Mouse Cursor in Button Editor Using Macro

XL98: Wrong Date Returned When You Enter Month and Digits

XL98: Year 2000 Wizards for Microsoft Excel 98