{"id":3173,"date":"2024-02-24T09:57:15","date_gmt":"2024-02-24T09:57:15","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=3173"},"modified":"2024-02-25T18:05:16","modified_gmt":"2024-02-25T18:05:16","slug":"fix-runtime-error-438-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel","title":{"rendered":"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">While handling Excel spreadsheets or running a VBA code, encountering errors isn\u2019t uncommon. One such cryptic error message that often baffles users is- \u201c<strong>Run time error 438 Object doesn&#8217;t support this property or method<\/strong>.&#8221; In this article, I will explore the intricacies of this annoying error, its common causes, and provide quick solutions to resolve it.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<p style=\"text-align: justify;\"><strong>Error Screenshot:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3178 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/29ea0b0e-914d-443d-9abf-e84ef96b0642.png\" alt=\"Run time error 438\" width=\"542\" height=\"224\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/29ea0b0e-914d-443d-9abf-e84ef96b0642.png 542w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/29ea0b0e-914d-443d-9abf-e84ef96b0642-300x124.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To repair corrupted Excel workbook and its objects, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h3><strong>Quick Fixes:<\/strong><\/h3>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<ol>\n<li style=\"text-align: left;\"><strong><a href=\"#s1\">Check The Codings<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s2\">Check the Object References<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s3\">Get the Latest Supporting MS Office Version\u00a0<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s4\">Uninstall Microsoft Works Add-in<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s5\">Use Microsoft Fix-It #50356<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s6\">Reinstall The Device Drivers For The Device<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s7\">Repair Corrupted Excel Workbook &amp; Its Components<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>What Does Error 438 Mean?<\/strong><\/h2>\n<p style=\"text-align: justify;\">When you try to execute the designed macro of MS Excel&#8217;s previous version into the latest MS Excel application, this error occurs. \u201c<strong>Run-time error \u201c438\u201d: Object doesn\u2019t support this property or method<\/strong>\u201d indicates that the referring object doesn\u2019t support the property or method when executing the Excel VBA.<\/p>\n<p style=\"text-align: justify;\">Other situations in which you can face this hiccup:<\/p>\n<ol>\n<li style=\"text-align: left;\">When an Excel user creates a toolbar in Excel by using visual basic code.<\/li>\n<li style=\"text-align: left;\">Trying to use variables for workbook &amp; worksheet name.<\/li>\n<li style=\"text-align: left;\">When executing a program within which form is already allotted to a variable.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Why Runtime Error 438 Excel Occurs?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Before addressing the error, it&#8217;s essential to extract the root causes. Here are some common reasons behind this vexing error:<\/p>\n<ol>\n<li>Incorrect object references<\/li>\n<li>Corrupt or faulty Microsoft Works add-in<\/li>\n<li>Missing or corrupted Excel components<\/li>\n<li>Using an older version of the MS Office application<\/li>\n<li>Mismatched data types.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">After catching the major culprits now you can easily make a keen check on how do i fix runtime error 438 in Excel.<\/p>\n<h2 style=\"text-align: left;\"><strong>Methods to Fix Excel Run Time Error 438 Object Doesn&#8217;t Support This Property or Method<\/strong><\/h2>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Note<\/strong><\/span>: Try the below solutions carefully as some of the listed fixes may hamper your system settings if performed incorrectly.<\/p>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 1- Check The Codings<\/strong><\/h3>\n<p style=\"text-align: justify;\">As we have already discussed, this error also occurs due to the incorrect creation of a macro or when the user tries to run the macro in which Excel objects don\u2019t support the property or method. In such a situation, you need to tap on the <strong>Debug<\/strong> option or rewrite the coding within the VBA module.<\/p>\n<p style=\"text-align: justify;\">If you are not having good command over the programming then you can contact <strong><a href=\"https:\/\/www.directionsonmicrosoft.com\/services\/microsoft-advisory-service\/\" target=\"_blank\" rel=\"noopener nofollow\">Microsoft Advisory Services<\/a>.<\/strong><\/p>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 2- Check the Object References<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another foremost reason behind this error is missing or incorrect object references. All you need to do is to check whether the specified references are missing or incorrect, if found any issue then do correct them within the macros.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><span style=\"color: #ff0000;\"><strong>Also Read: <\/strong><\/span><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-424-object-required\">Solving Run Time Error 424 Object Required in Excel: Your Last Stop!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 3- Get the Latest <\/strong><strong>Supporting <\/strong><strong>MS Office Version\u00a0<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Excel object doesn&#8217;t support this property or method (error 438)<\/strong> also encountered while trying to work with the outdated macro function designed in the older version in the latest versions of MS Office application.<\/p>\n<p style=\"text-align: justify;\">For this, I will recommend you get the supported version of the MS Office application in which you have designed it.<\/p>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 4- <\/strong><strong>Uninstall Microsoft Works Add-in<\/strong><\/h3>\n<p style=\"text-align: justify;\">It is seen that the Microsoft Works add-in generates this runtime error 438 Excel<strong>.\u00a0 <\/strong>So, uninstall this add-in just by following these steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the <strong>Start <\/strong>menu then click the <strong>Settings <\/strong>option and then on the <strong>Control Panel.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7808 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/01\/comtrol-panel-1.png\" alt=\"Control Panel\" width=\"674\" height=\"631\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Now tap the <strong>Add \/ Remove Programs.<\/strong><\/li>\n<li style=\"text-align: left;\">Hit the <strong>File Location <\/strong>present within the\u00a0<strong style=\"font-style: inherit;\">Options.<\/strong><\/li>\n<li style=\"text-align: left;\">From <strong>Uninstall\/Install<\/strong> tab, choose the add-in suit i.e.<strong> Excel in Works. <\/strong>After that, tap the<strong> Add \/ Remove.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-8174 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/02\/Excel-run-time-error-438.png\" alt=\"run time error 438 \" width=\"682\" height=\"638\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Now carefully follow the\u00a0<strong style=\"font-style: inherit;\">screen instructions.<\/strong><\/li>\n<li style=\"text-align: left;\"><strong style=\"font-style: inherit;\">Restart your PC <\/strong>and attempt to load Microsoft Excel again.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">This will stop the error from occurring again because you have successfully uninstalled the problem causing <strong>Works for Word add-in<\/strong> the program.<\/p>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 5- <\/strong><strong>Use Microsoft Fix-It #50356 to Fix Run Time Error 438 Object Doesn&#8217;t Support This Property Or Method<\/strong><\/h3>\n<p style=\"text-align: justify;\">In many cases it is found that by downloading the Microsoft Fix-It #50356 user has successfully overcome the <strong>Excel error &#8216;438&#8217;:<\/strong><strong> Object doesn&#8217;t support this property or method.<\/strong><\/p>\n<p style=\"text-align: justify;\">So, you can also download the Microsoft Fix-It Patch from <strong><a href=\"https:\/\/support.microsoft.com\/en-in\/help\/2970908\/how-to-use-microsoft-easy-fix-solutions\" target=\"_blank\" rel=\"noopener nofollow\">this link<\/a><\/strong>.<em><strong>\u00a0<\/strong><\/em>After complete downloading, the wizard will assist you throughout the tasks that you have to perform.<\/p>\n<p style=\"text-align: justify;\">Through this <strong>Microsoft #50356 hotfix <\/strong>broken registry strings that are causing the issue can easily be repaired. This patch gives new keys on the behave of broken registry keys. If your registry keys are broken then your Windows application displays the error message. But after downloading this new patch on your PC your Window won\u2019t show any error.<\/p>\n<p style=\"text-align: justify;\">If even after trying the above fixes the problem won\u2019t resolve then move to the next solution.<\/p>\n<p><a name=\"s6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 6-<\/strong>\u00a0<strong>Reinstall The Device Drivers For The Device <\/strong><\/h3>\n<p style=\"text-align: justify;\">Reinstalling the device driver can solve the Excel error 438. Try the following steps<strong>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to your system taskbar and tap on the <strong>start<\/strong> button. Here you will see a search box, in this box type <strong>device manager. <\/strong><\/li>\n<li>After that choose the <strong>Device Manager<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8175 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2024\/02\/Device-manager.png\" alt=\"run time error 438\" width=\"610\" height=\"480\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Make a right-click on the device name you need to uninstall and choose the <strong>Uninstall <\/strong>option.<\/li>\n<li>After uninstalling the device, <strong>restart<\/strong> your PC.<\/li>\n<li>Windows will try for driver reinstallation.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3185 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Reinstall-The-Drivers.png\" alt=\"Reinstall The Drivers For The Device\" width=\"700\" height=\"554\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Reinstall-The-Drivers.png 700w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Reinstall-The-Drivers-300x237.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><br \/>\n<a name=\"s7\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Fix 7- Repair Corrupted Excel Workbook &amp; Its Components<\/strong><\/h3>\n<p style=\"text-align: justify;\">Sometimes Excel sheet gets damaged or corrupted due to various reasons. Once the Excel spreadsheet gets corrupted, you can\u2019t access it anymore or it starts throwing errors. In such a case, you should immediately go for Excel&#8217;s built-in <strong>Open and Repair<\/strong> tool to repair the corrupt file for free. To learn how to use this utility, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53\" target=\"_blank\" rel=\"noopener\"><strong>Click Here<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\">Hence for a quick solution to repair and restore corrupt Excel files go with the recommended <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\"><strong>Excel Repair Tool<\/strong><\/a>. It is the best software for repairing severely damaged Excel files. It deeply scans the selected Excel files without making any changes to the original content and restores all the charts, objects, hidden sheets, pictures, clip charts, and other important Excel file content.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-excel-cannot-use-object-linking-and-embedding\">Fix Excel Cannot Use Object Linking And Embedding Error<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Does Excel Run-time Error 438 Occur When Running Macros?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThis error generally occurs due to invalid macro code, faulty Excel add-ins or running an outdated Excel version.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Fix Macro Error 438?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo fix macro error 438 in Excel, you can clear the cache &amp; cookies, update the Excel version and add-ins, or repair the installation.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can Reinstalling Excel Resolve Object Doesn&#039;t Support This Property or Method (Error 438)?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, repairing or reinstalling the Excel can resolve object doesn't support this property or method Excel error, especially if it's caused by corrupted\/missing components.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is Paste Run Time Error 438 In VBA?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tA paste runtime error 438 in VBA means that using a property or method that does not apply to a particular object.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Is There A Difference Between Excel Run Time Error 438 And Other VBA Errors?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, run-time error 438 specifically pertains to issues with object properties or methods. Other Excel VBA errors may stem from different sources, like syntax errors or variable mismanagement.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Does Excel Run-time Error 438 Occur When Running Macros?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"This error generally occurs due to invalid macro code, faulty Excel add-ins or running an outdated Excel version.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Fix Macro Error 438?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To fix macro error 438 in Excel, you can clear the cache &amp; cookies, update the Excel version and add-ins, or repair the installation.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Can Reinstalling Excel Resolve Object Doesn't Support This Property or Method (Error 438)?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, repairing or reinstalling the Excel can resolve object doesn't support this property or method Excel error, especially if it's caused by corrupted\/missing components.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is Paste Run Time Error 438 In VBA?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"A paste runtime error 438 in VBA means that using a property or method that does not apply to a particular object.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Is There A Difference Between Excel Run Time Error 438 And Other VBA Errors?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, run-time error 438 specifically pertains to issues with object properties or methods. Other Excel VBA errors may stem from different sources, like syntax errors or variable mismanagement.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Bottom Line<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Excel run time error 438 object doesn&#8217;t support this property or method<\/strong> can be a baffling problem in worksheet automation &amp; VBA programming. However, by identifying the major factors, and implementing the appropriate solutions mentioned in this blog, you can overcome this error &amp; streamline your Excel workflow.<\/p>\n<p>Good luck!<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel\/pop-up-error-run-time-error-438-object-doesn-t-support-this\/m-p\/3593121\" target=\"_blank\" rel=\"noopener\">https:\/\/techcommunity.microsoft.com\/t5\/excel\/pop-up-error-run-time-error-438-object-doesn-t-support-this\/m-p\/3593121<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>While handling Excel spreadsheets or running a VBA code, encountering errors isn\u2019t uncommon. One such cryptic error message that often &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#more-3173\" aria-label=\"Read more about Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":3179,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[1683,1682,1681],"class_list":["post-3173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-run-time-error-438-object-doesnt-support-this-property-or-method","tag-object-doesnt-support-this-property-or-method-error-438","tag-runtime-error-438-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fix Excel \u201cRun Time Error 438: Object Doesn&#039;t Support This Property or Method\u201d<\/title>\n<meta name=\"description\" content=\"Struggling with Excel run time error 438 object doesn&#039;t support this property or method? Learn easy strategies to fix this error head-on.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fix Excel \u201cRun Time Error 438: Object Doesn&#039;t Support This Property or Method\u201d\" \/>\n<meta property=\"og:description\" content=\"Struggling with Excel run time error 438 object doesn&#039;t support this property or method? Learn easy strategies to fix this error head-on.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-24T09:57:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-25T18:05:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d\",\"datePublished\":\"2024-02-24T09:57:15+00:00\",\"dateModified\":\"2024-02-25T18:05:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\"},\"wordCount\":1297,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png\",\"keywords\":[\"excel run-time error '438' object doesn't support this property or method\",\"object doesn't support this property or method (error 438)\",\"runtime error 438 Excel\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\",\"name\":\"Fix Excel \u201cRun Time Error 438: Object Doesn't Support This Property or Method\u201d\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png\",\"datePublished\":\"2024-02-24T09:57:15+00:00\",\"dateModified\":\"2024-02-25T18:05:16+00:00\",\"description\":\"Struggling with Excel run time error 438 object doesn't support this property or method? Learn easy strategies to fix this error head-on.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png\",\"width\":900,\"height\":500,\"caption\":\"Runtime Error 438 In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fix Excel \u201cRun Time Error 438: Object Doesn't Support This Property or Method\u201d","description":"Struggling with Excel run time error 438 object doesn't support this property or method? Learn easy strategies to fix this error head-on.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel","og_locale":"en_US","og_type":"article","og_title":"Fix Excel \u201cRun Time Error 438: Object Doesn't Support This Property or Method\u201d","og_description":"Struggling with Excel run time error 438 object doesn't support this property or method? Learn easy strategies to fix this error head-on.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2024-02-24T09:57:15+00:00","article_modified_time":"2024-02-25T18:05:16+00:00","og_image":[{"width":900,"height":500,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d","datePublished":"2024-02-24T09:57:15+00:00","dateModified":"2024-02-25T18:05:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel"},"wordCount":1297,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png","keywords":["excel run-time error '438' object doesn't support this property or method","object doesn't support this property or method (error 438)","runtime error 438 Excel"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel","name":"Fix Excel \u201cRun Time Error 438: Object Doesn't Support This Property or Method\u201d","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png","datePublished":"2024-02-24T09:57:15+00:00","dateModified":"2024-02-25T18:05:16+00:00","description":"Struggling with Excel run time error 438 object doesn't support this property or method? Learn easy strategies to fix this error head-on.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/excel-runtime-ERROR-438.png","width":900,"height":500,"caption":"Runtime Error 438 In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/fix-runtime-error-438-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Fix Excel \u201cRun Time Error 438: Object Doesn&#8217;t Support This Property or Method\u201d"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=3173"}],"version-history":[{"count":8,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3173\/revisions"}],"predecessor-version":[{"id":8177,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3173\/revisions\/8177"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/3179"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=3173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=3173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=3173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}