Results 1 to 2 of 2

did update cause code to stop working

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    did update cause code to stop working

    Code which has been running fine for months is now erring "out of range"

    Running Excel 2000 9.0.8950 SP-3
    recent updates:
    - XP Hotfix KB884038
    - Windows Imaging Component
    - Hotfix for Windows XP KB915800
    I have defragged.

    The code works on other computers running Excel 2000 9.0.2720
    It's not the workbook, the code doesn't work in any workbook.
    These are not consecutive lines of code, just examples of error locations:

    Error is 9 "out of range"
        If Workbooks("Book2").ReadOnly = False Then
        For Each ws In Workbooks("Book2").Worksheets
    (ws = Nothing)

    I can change Workbooks("Book2") to ThisWorkbook
    but I'd like to figure out why it quit working

    sample attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1