Runtime Error 9 appears when you try to copy a Microsoft Visual Basic for Applications module sheet in a Visual Basic macro procedure. It basically means that Visual Basic cannot read the commands / settings that you want it to – leading your system to show the error you’re seeing.
This error is normally displayed like this:
Run-time error ’9′:
Subscript out of range
