{"id":6981,"date":"2024-02-06T07:24:49","date_gmt":"2024-02-06T07:24:49","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=6981"},"modified":"2024-02-06T12:43:45","modified_gmt":"2024-02-06T12:43:45","slug":"excel-runtime-error-9-subscript-out-of-range","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range","title":{"rendered":"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!"},"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;\">Excel is one of the widely used spreadsheet programs. It is famous for its versatility &amp; efficiency in handling data. However, users often come across various runtime errors while handling the Excel worksheet, and one of the common ones is <strong>&#8220;Run time error 9 subscript out of range.&#8221;<\/strong> This blog aims to shed light on this specific error, its major reasons, and troubleshooting methods to overcome it in no time with less effort.<!--more--><\/p>\n<p><strong>Here is how the error message looks like:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6989 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/03-subscript-out-of-range-error.png\" alt=\"Excel run time error 9 subscript out of range\" width=\"372\" height=\"209\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/03-subscript-out-of-range-error.png 372w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/03-subscript-out-of-range-error-300x169.png 300w\" sizes=\"auto, (max-width: 372px) 100vw, 372px\" \/><\/p>\n<p style=\"text-align: justify;\">So, let\u2019s get started\u2026<\/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<h3 style=\"text-align: left;\"><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 style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Check the Range of the Array<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Verify the Worksheet Name in the VBA Code<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Change the Security Settings of Macro<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Repair the MS Excel File<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Best Software to Fix Corrupted Excel Document<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>What Is Error 9 Subscript Out of Range in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Runtime error 9 subscript out of range in Excel typically occurs when you try to access an array or a collection within the spreadsheet using an index that does not exist or is beyond the valid range.<\/p>\n<p style=\"text-align: justify;\">In simple words, this warning message commonly appears when the index specified in the <strong>VBA<\/strong> (Visual Basic for Applications) code is outside the defined range but Excel is unable to find the object referenced in the code.<\/p>\n<h2 style=\"text-align: left;\"><strong>Common Reasons for Excel VBA Runtime Error 9: Subscript Out of Range<\/strong><\/h2>\n<p style=\"text-align: justify;\">There are a wide variety of reasons that can lead to this run-time error message in Excel. Below I have listed the most common factors that can cause this annoying error:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Entered an incorrect statement syntax of an array.<\/li>\n<li>The entry or object that you\u2019re trying to use in the VBA code is either deleted or not defined earlier.<\/li>\n<li>If variable name spelling is incorrect then you can receive this error.<\/li>\n<li>Referenced an inappropriate array element.<\/li>\n<li>The Excel workbook is corrupted in which you are trying to use the VBA.<\/li>\n<li>An unspecified number of elements in the array.<\/li>\n<li>Specified an unacceptable element.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>How to Fix Excel Run Time Error 9 Subscript Out of Range?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Now, let\u2019s follow the below troubleshooting fixes to solve run-time error 9 subscript out of range Excel 2013\/2016\/2019.<\/p>\n<p><a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Solution 1- Check the Range of the Array<\/strong><\/h3>\n<p style=\"text-align: justify;\">As already mentioned in the causes section, the unspecified number of elements in the array of the code can trigger this <strong>VBA runtime error<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>For example<\/strong> \u2013 Suppose you\u2019ve stated an array &amp; forgot to state the array variable along with the elements, you can see the below-shown error:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6984 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/1-1.png\" alt=\"Runtime Error 9 Subscript Out of Range\" width=\"758\" height=\"273\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/1-1.png 758w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/1-1-300x108.png 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/p>\n<p style=\"text-align: justify;\">However, in order to resolve this, you have to specify an array variable like this:<\/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 style=\"text-align: justify;\"><strong><em>Sub FillArray()<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Dim curExpense(364) As Currency<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Dim intI As Integer<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>For intI = 0 to 364<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>curExpense(intI) = 20<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Next<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>End Sub<\/em><\/strong><\/p>\n<\/div><\/div>\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-vba-error-400\">Fix VBA Error 400 Running An Excel Macro?<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Solution 2- Verify the Worksheet Name in the VBA Code<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another method that you should try is to check if the worksheet name isn\u2019t defined properly in the VBA code.<\/p>\n<p style=\"text-align: justify;\"><strong>For example<\/strong>&#8211; When you try to copy the content from one MS Excel document to another Excel document by VBA code, and you have mentioned an incorrect worksheet name then you can get the below error:<\/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 style=\"text-align: justify;\"><strong><em>Private Sub CommandButton1_Click()<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Worksheets(&#8220;emp&#8221;).Range(&#8220;A1:E5&#8221;).Select<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Selection.Copy<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Worksheets(&#8220;emp3&#8221;).Activate<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Worksheets(&#8220;emp3&#8221;).Range(&#8220;A1:E5&#8221;).Select<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>ActiveSheet.Paste<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>Application.CutCopyMode = False<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>End Sub<\/em><\/strong><\/p>\n<\/div><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6985 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/2-1.png\" alt=\"run time error 9 subscript out of range excel\" width=\"623\" height=\"322\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/2-1.png 623w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/2-1-300x155.png 300w\" sizes=\"auto, (max-width: 623px) 100vw, 623px\" \/><\/p>\n<p style=\"text-align: justify;\">Now, when you try to run the code mentioned above, the MS Excel will show the \u201c<strong>VBA runtime error 9<\/strong>\u201d.<\/p>\n<p style=\"text-align: justify;\">If you want to check the worksheet name and correct it, follow the below steps:<\/p>\n<ul>\n<li style=\"text-align: left;\">First, you must click the <strong>Design<\/strong>\u00a0tab under <strong>Developer<\/strong>\u00a0section.<\/li>\n<li style=\"text-align: left;\">Then, double-tap on a <strong>Command<\/strong>\u00a0button.<\/li>\n<li style=\"text-align: left;\">After this, check &amp; modify the Excel worksheet name (for example from the \u201c<strong>emp<\/strong>\u201d to \u201c<strong>emp2<\/strong>\u201d).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6986 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/3-1.png\" alt=\"run time error 9 subscript out of range excel\" width=\"433\" height=\"191\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/3-1.png 433w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/3-1-300x132.png 300w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">At this time, run the code.<\/li>\n<li style=\"text-align: justify;\">The data in the \u2018<strong>emp\u2019<\/strong> sheet will be copied to the \u2018<strong>emp2\u2019<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6987 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/4-1.png\" alt=\"run time error 9 subscript out of range excel\" width=\"354\" height=\"520\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/4-1.png 354w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/4-1-204x300.png 204w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><br \/>\n<a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Solution 3- Change the Security Settings of Macro<\/strong><\/h3>\n<p style=\"text-align: justify;\">Most of the time, this <strong>VBA error subscript out of range 9<\/strong> also occurs in Excel if the macros are restricted in Macro Security Settings. However, in that case, you need to check &amp; change macro settings immediately.<\/p>\n<p style=\"text-align: justify;\">Follow these steps:<\/p>\n<ul>\n<li style=\"text-align: left;\">Open your MS Excel.<\/li>\n<li style=\"text-align: left;\">Go to the <strong>File <\/strong>then click on<strong> Options <\/strong>and then click<strong> Trust Center<\/strong>.<\/li>\n<li style=\"text-align: left;\">In the <strong>Trust Center<\/strong>, you have to choose the\u00a0<strong>Trust Center Settings<\/strong>.<\/li>\n<li style=\"text-align: left;\">Here, click on the <strong>Macro Settings<\/strong>, choose the\u00a0<strong>Enable all macros<\/strong> &gt;&gt; click on\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6988 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/5-1.png\" alt=\"run time error 9 subscript out of range excel\" width=\"824\" height=\"543\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/5-1.png 824w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/5-1-300x198.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/5-1-768x506.png 768w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><\/p>\n<p style=\"text-align: justify;\">If this method won\u2019t work for you, try the next one.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/resolve-excel-runtime-error-13\">Fix Excel Runtime Error 13 Type Mismatch<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Solution 4- Repair the MS Excel File to Fix Run Time Error 9 Subscript Out Of Range<\/strong><\/h3>\n<p style=\"text-align: justify;\">Sometimes, the name of the objects might get transformed due to file corruption. When the objects aren\u2019t recognized in the VBA code, you may receive this runtime error.<\/p>\n<p style=\"text-align: justify;\">In such a situation, you can go for an inbuilt Excel utility known as <strong>Open and Repair<\/strong>. It will eventually help you to fix your corrupted Excel file.<\/p>\n<p style=\"text-align: justify;\">Here\u2019s how you can use this tool:<\/p>\n<ul style=\"text-align: justify;\">\n<li>In your Excel, you have to click on the <strong>File &gt; Open<\/strong>.<\/li>\n<li>After this, browse to find the faulty file.<\/li>\n<li>Under\u00a0<strong>Open\u00a0<\/strong>dialog-box, choose a corrupted workbook.<\/li>\n<li>Under\u00a0<strong>Open <\/strong>dropdown, you have to click on the\u00a0<strong>Open and Repair<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7228\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair-1.png\" alt=\"run time error 9 subscript out of range\" width=\"864\" height=\"590\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair-1.png 972w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/09\/excel-open-and-repair-1-768x525.png 768w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Now, you\u2019ll get a prompt enquiring you to repair a file or extract data.<\/li>\n<li style=\"text-align: left;\">Finally, click on\u00a0<strong>Repair <\/strong>option to extract data. If the <strong>Repair<\/strong>\u00a0option fails, then you can click on\u00a0<strong>Extract Data.<\/strong> This will recover the data without values &amp; formulas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3715 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/07\/OPEN-AND-REPAIR.jpg\" alt=\"run time error 9 subscript out of range\" width=\"844\" height=\"146\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/07\/OPEN-AND-REPAIR.jpg 844w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/07\/OPEN-AND-REPAIR-300x52.jpg 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/07\/OPEN-AND-REPAIR-768x133.jpg 768w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/><br \/>\n<a name=\"s5\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Best Software to Fix Corrupted Excel Document<\/strong><\/h2>\n<p style=\"text-align: justify;\">If the \u201cOpen &amp; Repair\u201d utility and other manual methods fail to <strong>fix Excel VBA runtime error 9: subscript out of range<\/strong> error, it might be possible that your Excel file got corrupted. In such a case, you are suggested to go with the <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\"><strong>MS Excel Repair Tool<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\">It is one of the best &amp; most recommended feature-loaded utilities that can fix any type of problem, corruption, or error in Excel files <strong>(.xls, .xltm, .xlsx, .xltx, &amp; .xlsm<\/strong>). Apart from that, you can restore all the objects of your corrupt Excel files such as <strong>charts, formulas, cell comments, pivot tables<\/strong>, etc.<\/p>\n<p style=\"text-align: justify;\">So, just must download, install &amp; try this software to <a href=\"https:\/\/www.repairmsexcel.com\/blog\/13-ways-to-repair-corrupt-excel-file\" target=\"_blank\" rel=\"noopener\"><strong>repair your corrupt Excel file<\/strong><\/a> and deal with the Excel error that you are facing.<\/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<p style=\"text-align: justify;\">Here are the steps to use this tool:<\/p>\n\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Is Runtime Error 9 Specific to Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tNo, run time error 9 is not only occurs in Excel program while running VBA code, it can also occur in Access and other database programs when executing macro.                    <\/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 Runtime Error 9 &#039;: Subscript Out of Range in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can fix this error by applying the below tricks: <ul><li>Check the Range of the Array <\/li><li>Verify the Worksheet Name in the VBA Code <\/li><li> Check the References <\/li><li> Change the Security Settings of Macro <\/li><li>Repair the MS Excel File                     <\/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 Runtime Error Code 9 in Excel Be Prevented?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>Yes<\/strong>, by regularly checking object references, organizing workbooks, and maintaining consistency in Excel versions, you can minimize the likelihood of encountering runtime error 9.                    <\/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\": \"Is Runtime Error 9 Specific to Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"No, run time error 9 is not only occurs in Excel program while running VBA code, it can also occur in Access and other database programs when executing macro.\"\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 Runtime Error 9 ': Subscript Out of Range in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can fix this error by applying the below tricks: &lt;ul&gt;&lt;li&gt;Check the Range of the Array &lt;\/li&gt;&lt;li&gt;Verify the Worksheet Name in the VBA Code &lt;\/li&gt;&lt;li&gt; Check the References &lt;\/li&gt;&lt;li&gt; Change the Security Settings of Macro &lt;\/li&gt;&lt;li&gt;Repair the MS Excel File\"\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 Runtime Error Code 9 in Excel Be Prevented?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>Yes<\/strong>, by regularly checking object references, organizing workbooks, and maintaining consistency in Excel versions, you can minimize the likelihood of encountering runtime error 9.\"\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>Packing Up<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Excel run time error 9 subscript out of range<\/strong> can disrupt workflow efficiency &amp; hinder productivity. Nevertheless, by understanding its causes, and using effective troubleshooting methods discussed in this post, you can easily solve this error and enhance the Excel spreadsheet experience.<\/p>\n<p style=\"text-align: justify;\"><strong><em>Good Luck!!!<\/em><\/strong><\/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\/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-gb\/office\/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<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>Excel is one of the widely used spreadsheet programs. It is famous for its versatility &amp; efficiency in handling data. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#more-6981\" aria-label=\"Read more about Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":6990,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[1650,1481,1651],"class_list":["post-6981","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-run-time-error-9-subscript-out-of-range","tag-excel-vba-runtime-error-9-subscript-out-of-range","tag-runtime-error-9-subscript-out-of-range","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 Run Time Error 9 Subscript Out of Range in 5 Simple Ways!<\/title>\n<meta name=\"description\" content=\"Whether you&#039;re a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.\" \/>\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-runtime-error-9-subscript-out-of-range\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\" \/>\n<meta property=\"og:description\" content=\"Whether you&#039;re a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-06T07:24:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-06T12:43:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\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=\"8 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-runtime-error-9-subscript-out-of-range#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\",\"datePublished\":\"2024-02-06T07:24:49+00:00\",\"dateModified\":\"2024-02-06T12:43:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\"},\"wordCount\":1352,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png\",\"keywords\":[\"Excel run time error 9 subscript out of range\",\"excel VBA runtime error 9: subscript out of range\",\"runtime error 9 subscript out of range\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\",\"name\":\"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png\",\"datePublished\":\"2024-02-06T07:24:49+00:00\",\"dateModified\":\"2024-02-06T12:43:45+00:00\",\"description\":\"Whether you're a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png\",\"width\":580,\"height\":300,\"caption\":\"How to Fix Runtime Error 9 Subscript Out of Range in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!\"}]},{\"@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 Run Time Error 9 Subscript Out of Range in 5 Simple Ways!","description":"Whether you're a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.","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-runtime-error-9-subscript-out-of-range","og_locale":"en_US","og_type":"article","og_title":"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!","og_description":"Whether you're a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range","og_site_name":"Excel File Repair Blog","article_published_time":"2024-02-06T07:24:49+00:00","article_modified_time":"2024-02-06T12:43:45+00:00","og_image":[{"width":580,"height":300,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!","datePublished":"2024-02-06T07:24:49+00:00","dateModified":"2024-02-06T12:43:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range"},"wordCount":1352,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png","keywords":["Excel run time error 9 subscript out of range","excel VBA runtime error 9: subscript out of range","runtime error 9 subscript out of range"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range","name":"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png","datePublished":"2024-02-06T07:24:49+00:00","dateModified":"2024-02-06T12:43:45+00:00","description":"Whether you're a beginner or a seasoned Excel user, these tips will help you tackle run time error 9 subscript out of range issue with ease.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/06\/How-to-Fix-Runtime-Error-9-Subscript-Out-of-Range-in-Excel.png","width":580,"height":300,"caption":"How to Fix Runtime Error 9 Subscript Out of Range in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-runtime-error-9-subscript-out-of-range#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Fix Excel Run Time Error 9 Subscript Out of Range in 5 Simple Ways!"}]},{"@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\/6981","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=6981"}],"version-history":[{"count":6,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6981\/revisions"}],"predecessor-version":[{"id":8021,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6981\/revisions\/8021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/6990"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=6981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=6981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=6981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}