Runtime errors are mostly encountered due to missing files. Runtime error 9 occurs when a user tries to create a duplicate copy of application module of Visual Basic via a Visual Basic procedure. While working in Excel, if you encounter runtime error 9 or "Subscript out of range" error message, it indicates that visual basic finds these settings as unreadable which have caused errors in your system.

These errors generally appear if you try to "copy" and "paste" in Excel. This process of moving the actual copies of sheets to Excel workbook is responsible for causing error. This error code looks something like this:

"ThisWorkbook.Sheets ("Module2″).Copy before: =ActiveWorkbook.Sheets (1)"

          

In some situations, you will find this error if the copy has been manually inserted into Microsoft Excel or if a printer is not properly defined in the computer. So, it can be said that this is a case of faulty configuration. It also occurs due to application malfunctioning, virus attacks, invalid entries in your system etc. It has been found that viruses causes great damage to your system, especially to the vital programs in your system. If some crucial programs are damaged, they will automatically become unreadable and hence, system fails to process the commands correctly. And as a result it throws error messages.

As absence of printer on your system may lead to the occurrence of this errors, you may resolve this error by installing a printer by going to "Start" > "Control Panel" > "Printers and Faxes" Options. After that you will have to click on "Add a Printer" options and follow instructions for adding a default printer. But if this error still appears on your computer screen, you will have to take the help of third-party excel repair tools. These tools are built with high-end technology and are especially designed to resolve all sorts of excel errors.