Share this article

Improve this guide

Runtime Error 438: Object Doesn’t Support Property [Fix]

Use the right properties and methods for the selected object

4 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

The runtime error 438 error on Microsoft Visual Basic (VBA) is one of the most annoying issues users encounter. Like otherruntime errors like 3706, it stops you from executing your code on VBA.

Fortunately, as daunting as the issue looks, it is not the most difficult to fix, as shown in the ensuing sections of this detailed guide.

What does object doesn’t support property or method mean in Excel?

There are different objects you can use in VBA, and they all have properties and methods that are compatible with them.

However, if you try to use a property or method that is not supported by a particular method, you get the VBA runtime 438, which denotes that the property you are trying to use does not apply to the select object.

It must also be noted that this can sometimes be a false positive from a third-party antivirus. So, if you are sure you selected the correct property and method, you might need to disable or uninstall your antivirus.

How can I fix runtime error 438?

1. Use the right properties and methods

The easiest way to fix runtime error 438 is to use the properties and methods supported by the object you are using. If you can’t determine this yourself, press the dot after defining an object.

This will show the list of all properties and methods compatible with it. Another option is to press F2 to bring up the object browser. This will also list the properties that are applicable to an object.

2. Uninstall the Microsoft Works add-in

In some cases, the runtime error 438 might be due to issues with some of your Excel add-ins, like Microsoft Works. The best thing to do here is to uninstall these plugins and check if the error persists.

3. Scan for malware

If you are sure that your wrong properties or methods are not the cause of the runtime error 438, then it might be due to the activity of viruses on your PC.

You should use the Full Scan option or Microsoft Defender (Offline) to get rid of them. Alternatively, you can use a dedicated antivirus inESET NOD32.

This special software will scan the most hidden corner of your PC and eliminate even the most stubborn malware before it can cause problems.

4. Reinstall drivers

Some users have found this runtime error 438 due to problems with drivers for devices like your display adapter. To fix this, uninstall the affected driver and restart your PC.

5. Uninstall third-party antivirus

At times, the runtime error 438 might be a false alarm by your third-party antivirus. Also, the security software might be messing with your code for some reason.

In this case, you must uninstall the antivirus and use Microsoft Defender instead.

With this, we can now conclude this detailed guide on the VBA runtime error 438. All that is left for you is to follow the instructions therein, and the issue should be history.

If you are facing other issues likeruntime error 3709, check our detailed guide to fix it quickly.

Feel free to let us know the solution that helped you fix this issue in the comments below.

Runtime Error 438: Object Doesn’t Support Property [Fix]#

What does object doesn’t support property or method mean in Excel?#

How can I fix runtime error 438?#

1. Use the right properties and methods#

2. Uninstall the Microsoft Works add-in#

3. Scan for malware#

4. Reinstall drivers#

5. Uninstall third-party antivirus#