Technology

Runtime Error 438 Fix: How to Fix Runtime Error 438 When Using Office 2010

Run-time error 438 often appears when running Microsoft Excel and “Visual Basic” macros. The error occurs when the macros you are trying to use are wrong or flawed, essentially preventing Excel from running as smoothly as possible. If this error appears on your PC, you need to make sure that you can fix it as efficiently as possible.

This error will often show up in this format:

  • Run-time error ‘438 ′:
  • The object does not support this property or method

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

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

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

You should also use what is known as a “Registry Cleaner” program to correct any potential errors within your PC’s registry database. The registry database is a central storage system for all the files, settings, and options that Windows uses to help it function. Although this database is extremely important to your computer, it continually causes a number of potential problems for your PC. Runtime error 438 can occur if a registry database is corrupted, so it is strongly recommended that you clean this database from your system with a registry cleaning program.

Doing these steps will not only fix the potential problems within your computer, but it will also fix the errors that cause your PC to display the 438 runtime error. You must take every step to fix the 438 error for good.