The Runtime 9 error is a problem caused by your computer not being able to correctly process the functions & feature-calls which you require on your PC. The most typical cause of the error is that Microsoft Excel will be unable to read the “copied data” which you may have set up through a Visual Basic Macro command. If you find that your system is showing this error, you need to be able to repair the problems that are leading it to show – which can be done by first ensuring that your computer can correctly process the file and then allow Windows to run without any damaged settings.
The way to resolve runtime error 9 is to first add a printer to your system. As absurd as this might sound, the fact is that most Windows computers which show the runtime 9 error will not be able to read the settings it requires to run as it will be looking for information about a printer on your system. If you once had a printer or have one and do not use it, you should ensure that it’s attached to your PC. After doing that, you should also update the Windows system by clicking onto Start > Control Panel > Windows Update and then downloading all the updates you can. This will provide your PC with many fixes for the bugs & problems which can cause runtime errors, allowing your computer to run much smoother again.
Proceeding that, it’s also worth using a ‘registry cleaner’ program to scan through your computer and fix any of the potentially damaged errors inside. A registry cleaner is a software tool which is able to scan through your PC and fix errors which Windows will have with the settings stored inside the “registry database” of your system. This database is where your computer keeps all the files and settings it requires to run, and is a very important part of your computer. Although it’s extremely important, the registry is continually causing a large number of errors which can be fixed by downloading a registry repair program, installing it and then letting it fix any of the errors your system has. This should fix the runtime 9 error on your PC.