{"id":9383,"date":"2026-01-31T15:19:16","date_gmt":"2026-01-31T15:19:16","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=9383"},"modified":"2026-01-31T16:03:27","modified_gmt":"2026-01-31T16:03:27","slug":"excel-compile-error-byref-argument-type-mismatch","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch","title":{"rendered":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!"},"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;\">In MS Excel, VBA (Visual Basic for Applications) is generally used to automate tasks. But sometimes, while running VBA codes or macros in the worksheets, you may encounter numerous errors. One such runtime error is \u201c<strong>Compile error: ByRef argument type mismatch<\/strong>.\u201d It typically occurs when the data type of the argument doesn\u2019t match the data type of the parameter of the code.<!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9387 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-ByRef-argument-type-mismatch.png\" alt=\"Excel VBA Compile Error ByRef Argument Type Mismatch\" width=\"710\" height=\"262\" \/><\/p>\n<p style=\"text-align: justify;\">Below, I\u2019ll explain why this error actually occurs and how to fix the issue in no time.<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupted Excel files, 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<h2 style=\"text-align: left;\"><strong>What Causes VBA ByRef Argument Type Mismatch Worksheet Error?<\/strong><\/h2>\n<p style=\"text-align: justify;\">This runtime error in Excel can occur due to several reasons, such as:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Due to mismatched variable data types.<\/li>\n<li>Incorrect ByRef parameters<\/li>\n<li>Incorrectly passed arrays in the macros<\/li>\n<li>Corrupted workbook or worksheet<\/li>\n<li>Missing object references frequently cause confusion.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">After knowing the major factors behind this VBA error it\u2019s time to overcome this situation by applying the best practices.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Fix Excel VBA Compile Error Byref Argument Type Mismatch?<\/strong><\/h2>\n<p style=\"text-align: justify;\">The following are the workarounds you can try to fix the compile error in Microsoft Excel.<\/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<h3 style=\"text-align: left;\"><strong>Quick Navigation:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Renaming the Variable<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Verify the Mismatch Data Type<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Change the Macro Security Settings<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Use ByVal Instead ByRef<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Repair the Corrupted Workbook<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Check for Deleted Objects in a VBA or Macro<\/a><\/strong><\/li>\n<li><strong><a href=\"#s7\">Uninstalling Office Updates<\/a><\/strong><\/li>\n<li><strong><a href=\"#s8\">Copy the Entire Data to a New Workbook<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 1- Renaming the Variable<\/strong><\/h3>\n<p style=\"text-align: justify;\">Renaming the variable is an excellent workaround that may work for you to solve the problem. Doing this can assist you in getting rid of the problem related to the same name in the module.<\/p>\n<p style=\"text-align: justify;\">So, let\u2019s rename the variable:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the menu, click on\u00a0<strong>Debug.<\/strong><\/li>\n<li>After that, click on\u00a0<strong>Compile VBA project <\/strong>to allow your code to compile.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7647 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/09\/Compile-VBA-project.png\" alt=\"Compile VBA project\" width=\"696\" height=\"310\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/09\/Compile-VBA-project.png 824w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/09\/Compile-VBA-project-768x342.png 768w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><br \/>\n<a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 2- Verify the Mismatch Data Type<\/strong><\/h3>\n<p style=\"text-align: justify;\">Apart from mismatched variables, a mismatched data type in procedures often trigger <strong>VBA ByRef argument type mismatch worksheet error.<\/strong> All you need to do is align data types wisely in the VBA code to run it properly. Additionally, use explicit declarations always.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/invalid-outside-procedure-excel-error\">How to Fix Compile Error: Invalid Outside Procedure in Excel VBA?<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 3- Change the Macro Security Settings<\/strong><\/h3>\n<p style=\"text-align: justify;\">If macros are restricted in the Macro Security Settings, it can cause this error. In such a situation, you can check &amp; change the macro settings.<\/p>\n<p style=\"text-align: justify;\">Here is how you can do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Open your MS Excel.<\/li>\n<li style=\"text-align: left;\">Go to\u00a0<strong>File &gt;&gt; Options &gt;&gt; Trust Center<\/strong>.<\/li>\n<li style=\"text-align: left;\">After that, click on\u00a0<strong>Trust Center<\/strong>, choose\u00a0<strong>Trust Center Settings<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6028 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/12\/Excel-trust-center-settings.png\" alt=\"Trust Center Settings\" width=\"730\" height=\"457\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/12\/Excel-trust-center-settings.png 730w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/12\/Excel-trust-center-settings-300x188.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Lastly, click\u00a0<strong>Macro Settings<\/strong> &gt;&gt;\u00a0<strong>Enable all macros<\/strong>, and then hit\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8193 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/excel-options-macro-settings.png\" alt=\"Enable all macros\" width=\"1449\" height=\"403\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/excel-options-macro-settings.png 1449w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/excel-options-macro-settings-768x214.png 768w\" sizes=\"auto, (max-width: 1449px) 100vw, 1449px\" \/><br \/>\n<a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 4- Use ByVal Instead ByRef<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>Excel VBA compile error ByRef argument type mismatch error<\/strong> can even occur due to incorrect ByRef parameters in the macro or syntax. You can use the ByVal instead of the ByRef function to troubleshoot the problem. Using ByVal improves the code safety.<\/p>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 5- Repair the Corrupted Workbook<\/strong><\/h3>\n<p style=\"text-align: justify;\">The corrupted Excel workbook or worksheet is one of the major reasons for the occurrence of various errors, including argument type mismatch. If it has occurred due to file corruption, you can use the Open and Repair utility in Excel.<\/p>\n<p style=\"text-align: justify;\">To use this tool, follow these steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Open the Excel sheet, click <strong>File <\/strong>tab &gt;&gt;\u00a0<strong>Open<\/strong>.<\/li>\n<li style=\"text-align: left;\">Next, click\u00a0<strong>Browse <\/strong>option to select the affected file.<\/li>\n<li style=\"text-align: left;\">Under\u00a0<strong>Open\u00a0<\/strong>dialog box is shown. Click on the corrupted file.<\/li>\n<li style=\"text-align: left;\">Expand the arrow next to the\u00a0<strong>Open<\/strong>&gt;&gt; click\u00a0<strong>Open and Repair<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2290 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/04\/Open-and-Repair.jpg\" alt=\"Open-and-Repair\" width=\"675\" height=\"648\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/04\/Open-and-Repair.jpg 675w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/04\/Open-and-Repair-300x288.jpg 300w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Hit the <strong>Repair<\/strong> button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7229 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair.jpg\" alt=\"Repair Corrupt or Damaged Excel Workbook\" width=\"847\" height=\"174\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair.jpg 847w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair-768x158.jpg 768w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/p>\n<p style=\"text-align: justify;\">For a major file corruption issue, it is suggested to use the <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel Repair Software<\/strong><\/a>. It can repair severely corrupted <strong>XLS<\/strong> or <strong>XLSX<\/strong> files and recover all the components stored within them.<\/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<h3 style=\"text-align: left;\"><strong>Steps to Utilize MS Excel Repair Tool:<\/strong><\/h3>\n\n<a name=\"s6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 6- Check for Deleted Objects in a VBA or Macro<\/strong><\/h3>\n<p style=\"text-align: justify;\">Sometimes, this warning message occurs if an object you\u2019re calling in the VBA code isn\u2019t available, inaccessible, or deleted. Simply authenticate your VBA code with the Visual Basic Editor window for any missing or removed objects in the macro.<\/p>\n<p style=\"text-align: justify;\">Though debugging in the spreadsheet can help you quickly identify &amp; fix the VBA errors.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/repair-excel-2010-macro-compile-error-cant-find-project-library\">Excel Macro Compile Error Can\u2019t Find Project Or Library Error- 2025!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s7\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 7- Fix Excel VBA Compile Error ByRef Argument Type Mismatch by Uninstalling Office Updates<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another effective solution you can try is uninstalling the recently installed Office updates. It might be possible that the issue has occurred due to installed updates.<\/p>\n<p style=\"text-align: justify;\">Hence, to fix this, follow the below steps and uninstall the Office updates carefully:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Open Control Panel.<\/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;\">Go to the\u00a0<strong>Programs <\/strong>&gt;&gt; click\u00a0<strong>Program and Features.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7547 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/open-programs-and-features-in-control-panel.png\" alt=\"Control Panel\" width=\"600\" height=\"246\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Look for \u201c<strong>View Installed Updates<\/strong>\u201d &gt;&gt; click on the chosen Office updates.<\/li>\n<li style=\"text-align: left;\">After that, right-click on it &amp; click\u00a0<strong>Uninstall<\/strong>.<\/li>\n<li style=\"text-align: left;\">Now, follow the onscreen instructions to complete the uninstallation process.<\/li>\n<li style=\"text-align: left;\">When the process completes, restart the system.<\/li>\n<\/ul>\n<p><a name=\"s8\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Trick 8- Copy the Entire Data to a New Workbook <\/strong><\/h3>\n<p style=\"text-align: justify;\">If none of the above solutions worked for you, you can try copying the entire data from an old workbook to a new one. This solution will eventually <strong>fix the by reference argument type mismatch VBA<\/strong>.<\/p>\n<p style=\"text-align: justify;\">For this, you have to:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Launch Excel &gt;&gt;\u00a0<strong>create a blank <\/strong>or\u00a0<strong>new workbook<\/strong>.<\/li>\n<li>Choose &amp;\u00a0<strong>copy entire data <\/strong>from the damaged file.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7605 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/05\/Microsoft-Excel-Workbook-1.png\" alt=\"Correct Cells Selection\" width=\"1214\" height=\"677\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/05\/Microsoft-Excel-Workbook-1.png 1214w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/05\/Microsoft-Excel-Workbook-1-768x428.png 768w\" sizes=\"auto, (max-width: 1214px) 100vw, 1214px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now, go and paste it into a new Excel document &gt;&gt;\u00a0<strong>save the new file<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">And you are done!<\/p>\n<h2 style=\"text-align: left;\"><strong>Unique FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Does ByRef Mean In VBA?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tByRef stands for \u2018By Reference\u2019. It is used when passing the arguments to a procedure (Sub or Function). Moreover, it allows the method to change the original variable directly.                    <\/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 Will You Pass Arguments to A VBA Function?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can pass an argument in a VBA code by value if you contain the \u2018ByVal\u2019 keyword in a procedure's declaration. Arguments passed via value consume from 2\u201316 bytes in the procedure, depending on the argument's data type.                    <\/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>Which Is the Default Argument Passed In VBA?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>ByRef<\/strong> is the default argument passed in VBA unlike in Visual Basic.                    <\/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 Type Mismatch Error in VB Script?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe Type Mismatch error occurs when the function doesn\u2019t understand the format of a number that is being cast.                    <\/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 to Solve Compile Error in Excel VBA?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo solve compile error in Excel VBA, try the below tips: <ul><li>Disable &amp; enable the Solver Add-in. <\/li><li>Remove Corrupted Solver VBA Components (if they exist).                     <\/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\": \"What Does ByRef Mean In VBA?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"ByRef stands for \u2018By Reference\u2019. It is used when passing the arguments to a procedure (Sub or Function). Moreover, it allows the method to change the original variable directly.\"\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 Will You Pass Arguments to A VBA Function?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can pass an argument in a VBA code by value if you contain the \u2018ByVal\u2019 keyword in a procedure's declaration. Arguments passed via value consume from 2\u201316 bytes in the procedure, depending on the argument's data type.\"\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\": \"Which Is the Default Argument Passed In VBA?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>ByRef<\/strong> is the default argument passed in VBA unlike in Visual Basic.\"\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 Type Mismatch Error in VB Script?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The Type Mismatch error occurs when the function doesn\u2019t understand the format of a number that is being cast.\"\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 to Solve Compile Error in Excel VBA?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To solve compile error in Excel VBA, try the below tips: &lt;ul&gt;&lt;li&gt;Disable &amp; enable the Solver Add-in. &lt;\/li&gt;&lt;li&gt;Remove Corrupted Solver VBA Components (if they exist).\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-argument-not-optional\">Excel Compile Error Argument Not Optional FIX \u2013 Stop the Crash!<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Summing Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">You may experience the <strong>Excel VBA compile error ByRef argument type mismatch <\/strong>while using a macro. However, you can try the methods discussed in this post to fix the error.<\/p>\n<p style=\"text-align: justify;\">If the error appears due to Excel file corruption, use the <strong>Excel Repair Tool<\/strong>.\u00a0It helps to repair the corrupt file and recover all the data from it without changing the original formatting.<\/p>\n<p style=\"text-align: justify;\">Consequently, your VBA projects remain stable and professional.<\/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:\/\/support.microsoft.com\/en-us\/office\/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/byref-argument-type-mismatch\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/byref-argument-type-mismatch<\/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>In MS Excel, VBA (Visual Basic for Applications) is generally used to automate tasks. But sometimes, while running VBA codes &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#more-9383\" aria-label=\"Read more about Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":9388,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2025,2026],"class_list":["post-9383","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-repair-excel","tag-excel-vba-compile-error-byref-argument-type-mismatch","tag-vba-byref-argument-type-mismatch-worksheet","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!<\/title>\n<meta name=\"description\" content=\"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.\" \/>\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\/excel-compile-error-byref-argument-type-mismatch\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\" \/>\n<meta property=\"og:description\" content=\"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-31T15:19:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-31T16:03:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"309\" \/>\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\/excel-compile-error-byref-argument-type-mismatch#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\",\"datePublished\":\"2026-01-31T15:19:16+00:00\",\"dateModified\":\"2026-01-31T16:03:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\"},\"wordCount\":1252,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png\",\"keywords\":[\"Excel VBA compile error ByRef argument type mismatch\",\"VBA ByRef argument type mismatch worksheet\"],\"articleSection\":[\"Repair Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\",\"name\":\"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png\",\"datePublished\":\"2026-01-31T15:19:16+00:00\",\"dateModified\":\"2026-01-31T16:03:27+00:00\",\"description\":\"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png\",\"width\":550,\"height\":309},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!\"}]},{\"@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":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!","description":"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.","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\/excel-compile-error-byref-argument-type-mismatch","og_locale":"en_US","og_type":"article","og_title":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!","og_description":"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch","og_site_name":"Excel File Repair Blog","article_published_time":"2026-01-31T15:19:16+00:00","article_modified_time":"2026-01-31T16:03:27+00:00","og_image":[{"width":550,"height":309,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.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\/excel-compile-error-byref-argument-type-mismatch#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!","datePublished":"2026-01-31T15:19:16+00:00","dateModified":"2026-01-31T16:03:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch"},"wordCount":1252,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png","keywords":["Excel VBA compile error ByRef argument type mismatch","VBA ByRef argument type mismatch worksheet"],"articleSection":["Repair Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch","name":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png","datePublished":"2026-01-31T15:19:16+00:00","dateModified":"2026-01-31T16:03:27+00:00","description":"In this post, I break down exactly why Excel VBA compile error ByRef argument type mismatch error occurs, and how to fix it.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2026\/01\/Excel-VBA-compile-error-byref-argument-type-mismatch1.png","width":550,"height":309},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-compile-error-byref-argument-type-mismatch#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel VBA Compile Error ByRef Argument Type Mismatch \u2013 Stop This Error Forever!"}]},{"@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\/9383","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=9383"}],"version-history":[{"count":5,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9383\/revisions"}],"predecessor-version":[{"id":9386,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9383\/revisions\/9386"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/9388"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=9383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=9383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=9383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}