{"id":10983,"date":"2022-07-28T09:49:11","date_gmt":"2022-07-28T09:49:11","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=10983"},"modified":"2024-03-30T00:03:07","modified_gmt":"2024-03-30T00:03:07","slug":"clear-memory-in-vba","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/","title":{"rendered":"Clear Memory in VBA"},"content":{"rendered":"\n<p>The Excel VBA <strong>Out of memory<\/strong> error (<strong>Run-time error 7<\/strong>) occurs when Excel runs out of system resources to continue running the macro.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Causes of Out of memory error<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"215\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\" alt=\"\" class=\"wp-image-10985\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg 373w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1-300x173.jpeg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/figure>\n\n\n\n<p>Excel can run out of system resources to run macros in the following situations:<\/p>\n\n\n\n<ul>\n<li>When we work with a workbook that contains many worksheets and thousands of rows. This error can occur faster when we are using the <strong>32-bit version of Excel<\/strong> that can use only up to a maximum of 2GB of available physical memory on the machine.<\/li>\n\n\n\n<li>When we create a loop in Excel VBA that works with a very large dataset. This worsens if we mistakenly created a perpetual loop in the code.<\/li>\n\n\n\n<li>When we work with multiple objects that are set with the <strong>Set<\/strong> keyword and we do not clear the references to the objects between loops or procedures.<\/li>\n\n\n\n<li>This error could happen when we run a macro when we have many other applications running in addition to Excel.<\/li>\n\n\n\n<li>When we set a worksheet\u2019s used range that is too large to fit into memory.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Clear memory in Excel VBA<\/h2>\n\n\n\n<p>It is good practice to clear the memory in Excel VBA after running procedures to ensure optimal system performance.<\/p>\n\n\n\n<p>The following are methods we can use to clear system memory in Excel VBA:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Method 1: Nullify objects when they are no longer needed<\/h3>\n\n\n\n<p>If we work with <strong>Objects<\/strong> and <strong>Loops<\/strong> in our procedures, we need to ensure that the <strong>Objects<\/strong> are set to <strong>Nothing<\/strong> once the Objects have been used and we no longer need them. We can follow the example below:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub nullifyObject()\n    \tDim largeObject As Object\n\tSet largeObject= Application.Worksheets( \"Sheet1\").Range(\"A1:D400\")\n    \t\t'loop construct\n    Set someLargeObject = Nothing\nEnd Sub<\/code><\/pre>\n\n\n\n<p>Setting Object variables to Nothing will free up the memory taken up by the Objects.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Method 2: Clear Excel clipboard<\/h3>\n\n\n\n<p>If our subroutine copies data from and to ranges, it is good practice that we clear the Excel clipboard before exiting the procedure. This is achieved by placing the Application.CutCopyMode = False statement just before ending the procedure as in the example code below.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub clearClipboard()\n    Range(\"A1:A5\").Select\n    Selection.Copy\n    Range(\"C1\").Select\n    ActiveSheet.Paste\n    Application.CutCopyMode = False\nEnd Sub<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Prevent an Out of memory error<\/h2>\n\n\n\n<p>The following are some measures we can take to prevent the <strong>Out of memory<\/strong> error in Excel VBA.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 1: Ensure only one instance of Excel is running<\/h3>\n\n\n\n<p>Many instances of Excel running at the same time take up more memory resources. The way to check if there are multiple instances of Excel running is by:<\/p>\n\n\n\n<ol>\n<li>Press <strong>Ctrl + Alt + Delete<\/strong> on the keyboard to open the <strong>Task Manager<\/strong>. In the example below 2 instances of the Excel file are running.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"190\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-2.jpeg\" alt=\"\" class=\"wp-image-10986\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-2.jpeg 412w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-2-300x138.jpeg 300w\" sizes=\"(max-width: 412px) 100vw, 412px\" \/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>To close the instances we do not need, select that instance and click <strong>End Task<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"463\" height=\"459\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-3.jpeg\" alt=\"\" class=\"wp-image-10987\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-3.jpeg 463w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-3-300x297.jpeg 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-3-150x150.jpeg 150w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 2: Close all unnecessary applications<\/h3>\n\n\n\n<p>If in addition to Excel we have several other programs open, this reduces the amount of memory available to Excel. Closing these other programs can prevent the <strong>Out of memory<\/strong> error.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 3: Reduce the size of the Excel file<\/h3>\n\n\n\n<p>Sometimes our procedure may be accessing rows and columns that are outside the range that contains data. These empty rows and columns take up memory. We can check for this by pressing <strong>Ctrl + Shift + End<\/strong> on the keyboard. If the cell selector lands way below the last cell that has data, then we have to <a href=\"https:\/\/officetuts.net\/excel\/vba\/delete-empty-rows-in-excel-with-vba\/\">delete all the empty rows<\/a> and columns that are above the cell selector and save the file. This reduces the size of the Excel file and hence takes up less memory when it is set to an object variable.<\/p>\n\n\n\n<p>Another way of reducing the size of the Excel file is to remove unused sheets, conditional formatting, validation, filtering, and so on.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 4: Uninstall Add-ins that we do not use<\/h3>\n\n\n\n<p>Add-ins take up memory. We can uninstall the ones that we do not use.<\/p>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol>\n<li>Click on <strong>File<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"211\" height=\"138\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-4.jpeg\" alt=\"\" class=\"wp-image-10988\"\/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Select <strong>Options<\/strong> on the sidebar.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"137\" height=\"104\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-5.jpeg\" alt=\"\" class=\"wp-image-10989\"\/><\/figure>\n\n\n\n<ol start=\"3\">\n<li>In the <strong>Excel Options<\/strong> dialog box select the <strong>Add-ins<\/strong> category, select <strong>Excel Add-ins<\/strong> or <strong>COM Add-ins<\/strong> in the <strong>Manage<\/strong> drop-down list, then click<strong> Go<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"570\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-6.jpeg\" alt=\"\" class=\"wp-image-10990\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-6.jpeg 630w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-6-300x271.jpeg 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/figure>\n\n\n\n<ol start=\"4\">\n<li>Deselect the <strong>Add-ins<\/strong> we want to be uninstalled in the <strong>Add-ins available<\/strong> list box and click <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"404\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-7.jpeg\" alt=\"\" class=\"wp-image-10991\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-7.jpeg 325w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-7-241x300.jpeg 241w\" sizes=\"(max-width: 325px) 100vw, 325px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 6: Do not use Global variables unless necessary<\/h3>\n\n\n\n<p>Whereas <strong>procedure-level variables <\/strong>are destroyed at the end of the procedure thus freeing up memory, <strong>Global variables<\/strong> remain in memory throughout the runtime of Excel. It is therefore recommended that we do not use Global variables if persistence between procedure calls is not necessary.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 7: Change the structure of the VBA code<\/h3>\n\n\n\n<p>If we have lengthy procedures in the same module, we can change the structure of the code such that batches of it occupy different modules.<\/p>\n\n\n\n<p>If our code is using arrays, we can use the <strong>Erase function<\/strong> to free the memory of <strong>dynamic arrays<\/strong> and reset the values of <strong>fixed arrays<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 8: Set Application.ScreenUpdating to False<\/h3>\n\n\n\n<p>If we have a macro that is updating the screen constantly when it is not necessary, we can set Application.ScreeenUpdating = False. This will not only speed up the execution of the code but also save on memory usage.<\/p>\n\n\n\n<p>We must remember to set the Application.ScreeenUpdating = True at the end of the macro.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 9: Switch to the 64-bit version of Excel<\/h3>\n\n\n\n<p>The 32-bit version of Excel only allows the use of a maximum of 2GB of all the physical memory available to the device. Large excel files that need resources above 2GB will cause an <strong>Out of memory error<\/strong>.<\/p>\n\n\n\n<p>If we need to use more than 2GB of memory then we can switch to Excel 64-bit version. This version allows the use of all the available memory available on the machine.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Measure 10: Increase the RAM on the device<\/h3>\n\n\n\n<p>Increasing the amount of <strong>physical RAM<\/strong> on our device can prevent the <strong>Out of memory<\/strong> error. It is important to remember that because of the 2GB limit on Excel 32-bit version, this measure can only have a significant effect on the 64-bit version of Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The Excel VBA <strong>Out of memory<\/strong> error (<strong>Run-time error 7<\/strong>) occurs when Excel runs out of available system resources to continue running the macro.<\/p>\n\n\n\n<p>In this tutorial we looked at some methods we can use to clear the memory in Excel VBA and several measures we can take to prevent this error.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel VBA Out of memory error (Run-time error 7) occurs when Excel runs out of system resources to continue running the macro&#8230;.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Clear Memory in VBA<\/title>\n<meta name=\"description\" content=\"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Clear Memory in VBA\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-28T09:49:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T00:03:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\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:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Clear Memory in VBA\",\"datePublished\":\"2022-07-28T09:49:11+00:00\",\"dateModified\":\"2024-03-30T00:03:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\"},\"wordCount\":1018,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"vba\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\",\"url\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\",\"name\":\"Clear Memory in VBA\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\",\"datePublished\":\"2022-07-28T09:49:11+00:00\",\"dateModified\":\"2024-03-30T00:03:07+00:00\",\"description\":\"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Clear Memory in VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Clear Memory in VBA","description":"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.","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:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/","og_locale":"en_US","og_type":"article","og_title":"Clear Memory in VBA","og_description":"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.","og_url":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/","article_published_time":"2022-07-28T09:49:11+00:00","article_modified_time":"2024-03-30T00:03:07+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Clear Memory in VBA","datePublished":"2022-07-28T09:49:11+00:00","dateModified":"2024-03-30T00:03:07+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/"},"wordCount":1018,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg","keywords":["pinterest"],"articleSection":["vba"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/","url":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/","name":"Clear Memory in VBA","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg","datePublished":"2022-07-28T09:49:11+00:00","dateModified":"2024-03-30T00:03:07+00:00","description":"Learn how to fix the Excel VBA Out of Memory error (Run-time error 7) by identifying its causes and clearing memory in Excel VBA.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/07\/word-image-10983-1.jpeg"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/vba\/clear-memory-in-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Clear Memory in VBA"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10983"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=10983"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10983\/revisions"}],"predecessor-version":[{"id":15798,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10983\/revisions\/15798"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=10983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=10983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=10983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}