Important Update: RealData discontinued new software sales on April 30, 2026. Existing software will continue to work, and licensed users should download and save their installers, as technical support will end on May 30, 2026.

View Categories

Run-time error 9: Subscript out of range

You receive a “Run-time error 9: Subscript out of range” Visual Basic error message when opening your RealData software program in Excel 2007.

It is likely that the .xlam file which provides the custom RealData menu for Excel is missing from your computer.  Reinstalling the software should fix this issue.

It is best to download the latest release of your software to assure Excel 2007 compatibility; releases prior to May 2007 are not compatible with Excel 2007.