Runtime error 438 often shows when running Microsoft Excel and “Visual Basic” macros. The error is caused when the macros you’re trying to use are either incorrect or erroneous and basically, prevent Excel from running as smoothly as possible anymore. If you have this error appearing on your PC, you need to be sure you can fix it in the most effective way possible.

This error will often show in this format:

  • Run-time error ‘438′:
  • Object doesn’t support this property or method

The error itself is caused by the “macro” you’re using either trying to use outdated functions (if you designed the macro in a previous version of Office, and now let it run in Office 2010) or if the macro just doesn’t work at all. This issue can be fixed by repairing the macro you’re trying to use or by repairing the installation of Microsoft Office on your computer.

The first step to fixing the 438 error is to uninstall the Microsoft Works add-in for Office. This often causes conflict with the Office software. This can be done by clicking on Start > Control Panel > Add / Remove Programs, and then locating the “Microsoft Works” add-in. Removing it should stop any further conflict within your system.

After removing this add-in, you then need to apply the Microsoft hotfix #50356. This has been specially designed to fix the problems that are causing the 438 error, and basically, allow you to quickly enable your computer to run as smoothly as possible again without having to uninstall any more software you may want to use.

You should also look to use what’s known as a “Registry Cleaner” program to cure any potential errors inside the registry database of your PC. The registry database is a central storage system for all the files, settings and options that Windows uses to help it run. Although this database is extremely important for your computer, it’s continually causing a number of potential issues for your PC. The Runtime 438 error can occur if a registry database is corrupted, which is why it’s highly recommended you clean out this database of your system with a registry cleaner program.

Doing these steps will not only fix the potential problems inside your computer but will also fix the errors that are causing your PC to show the 438 runtime error. You should perform each step in order to cure the 438 error for good.