How to Fix the Runtime Error 9: Subscript Out of Range

Written by susan reynolds
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Fix the Runtime Error 9: Subscript Out of Range
A runtime error is fairly easy to fix. (error image by dead_account from

Runtime errors occur when files are missing. If you receive a message that says "Run-time error 9: Subscript out of range," that means Visual Basic is unable to read commands. This error commonly shows up if you attempt to copy pages into an Excel file. Another reason could be that you do not have a default printer on your computer. There are several solutions to fix this Runtime Error 9 problem, so try them all in order.

Skill level:

Other People Are Reading


  1. 1

    Plug a printer into your computer, plug in the power cord and turn it on.

  2. 2

    Go to "Start" > "Control Panel" > "Printers and Faxes."

  3. 3

    Click "Add a Printer" and follow the instructions on the screen to add a default printer.

  1. 1

    Go to "Start" > "Control Panel."

  2. 2

    Click "Windows Update" to see if there are any updates available for your computer.

  3. 3

    Click "Check for Updates" and then download and install any recommended files.

  1. 1

    Download and install a Registry cleaner. (See Resources.)

  2. 2

    Open the program and direct the program to scan your Registry. It will find any files that are damaged.

  3. 3

    Direct the program to fix the Registry errors automatically. Restart your computer when the program is finished fixing or restoring any corrupted files.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.