Loading ...

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

Updated February 21, 2017

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.

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

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

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

  4. Go to "Start" > "Control Panel."

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

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

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

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

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

Loading ...

About the Author

Susan Reynolds has been a writer since 2008. She holds a B.A. in English from the University of South Florida and is a licensed real estate agent in Florida.

Loading ...