{"id":11627,"date":"2022-09-26T17:30:05","date_gmt":"2022-09-26T08:30:05","guid":{"rendered":"https:\/\/prodskill.com\/?p=11627"},"modified":"2022-10-04T23:07:30","modified_gmt":"2022-10-04T14:07:30","slug":"excel-vba-coding-pattern-performance-improvement","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/","title":{"rendered":"VBA Coding Patterns: Improving VBA Performance"},"content":{"rendered":"<p>In this article, we will look at how to improve VBA performance.<\/p>\n\n\n\n<p>In the previous article, we compared the VBA Range Loop method and confirmed that the method using Variant Array is the fastest.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-range-loop-read\/\">VBA Coding Pattern: Range Loop - Read<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\" >1. Performance related VBA global variables<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#11_ApplicationScreenUpdating\" >1.1. Application. ScreenUpdating<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#12_ApplicationDisplayAlerts\" >1.2. Application. DisplayAlerts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#13_ApplicationCalculation\" >1.3. Application. Calculation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#14_ApplicationEnableEvents\" >1.4. Application. EnableEvents<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2. Example code<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\" >2.1. When is it appropriate to apply<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/#22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\" >2.2. example code<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1._\uc131\ub2a5_\uad00\ub828_VBA_\uc804\uc5ed_\ubcc0\uc218\"><span class=\"ez-toc-section\" id=\"1_%EC%84%B1%EB%8A%A5_%EA%B4%80%EB%A0%A8_VBA_%EC%A0%84%EC%97%AD_%EB%B3%80%EC%88%98\"><\/span>1. Performance related VBA global variables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a summary of all variables.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\"><img loading=\"lazy\" decoding=\"async\" width=\"802\" height=\"345\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" alt=\"\uc131\ub2a5 \uad00\ub828 VBA \uc804\uc5ed \ubcc0\uc218\" class=\"wp-image-11628\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png 802w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-300x129.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-768x330.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-24x10.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-36x15.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179-48x21.png 48w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><figcaption>Performance related VBA global variables<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Examine the contents of each variable.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.1._Application.ScreenUpdating\"><span class=\"ez-toc-section\" id=\"11_ApplicationScreenUpdating\"><\/span>1.1. Application. ScreenUpdating<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a variable that controls whether the screen is updated or not, and the default value is True (screen is updated).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Performance improvement by setting not to refresh the screen (file conversion, sheet conversion, cell value setting, etc.) during VBA code execution<\/li><li>Effective when there are many screen refreshes<\/li><li>Set it to False at the entry of the code and set it back to True at the end of the code.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.2._Application.DisplayAlerts\"><span class=\"ez-toc-section\" id=\"12_ApplicationDisplayAlerts\"><\/span>1.2. Application. DisplayAlerts<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A variable that controls whether the warning window is displayed or not, and the default value is True (alert window is displayed).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Prevents the code from stopping in the middle by not displaying warning windows (e.g., \u201cDo you want to save\u201d when trying to close a file that has been changed) during VBA code execution<\/li><li>Set it to False at the entry of the code and set it back to True at the end of the code.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.3._Application.Calculation\"><span class=\"ez-toc-section\" id=\"13_ApplicationCalculation\"><\/span>1.3. Application. Calculation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This is a variable that controls the formula calculation method, and the default value is xlCalculationAutomatic (automatic calculation).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Prevent automatic calculation of formulas (COUNTIF, VLOOKUP, etc.) during VBA code execution<\/li><li>Effective for many formulas<\/li><li>Set it to xlCalculationManual at the entry of the code and set it back to xlCalculationAutomatic at the end of the code<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1.4._Application.EnableEvents\"><span class=\"ez-toc-section\" id=\"14_ApplicationEnableEvents\"><\/span>1.4. Application. EnableEvents<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It is a variable that controls whether to process events, and the default value is True (events are processed).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Prevent execution of code that handles events such as Worksheet_Change when they occur<\/li><li>This is effective if you have code that handles events.<\/li><li>Set it to False at the entry of the code and set it back to True at the end of the code.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"2_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2. Example code<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uc801\uc6a9\uc774_\uc801\ud569\ud55c_\uacbd\uc6b0\"><span class=\"ez-toc-section\" id=\"21_%EC%A0%81%EC%9A%A9%EC%9D%B4_%EC%A0%81%ED%95%A9%ED%95%9C_%EA%B2%BD%EC%9A%B0\"><\/span>2.1. When is it appropriate to apply<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If the VBA code contains the following cases, it is appropriate to apply the performance improvement method described in this article.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>When creating a new file\/sheet<\/li><li>When switching the current sheet to another sheet<\/li><li>In case of continuously changing the currently selected cell within one sheet<\/li><li>When performing complex calculations such as long calculations with many formulas<\/li><\/ul>\n\n\n\n<p>In this case, the execution of the VBA code is temporarily suspended, and events that require Excel, such as updating the screen or calculating formulas, are processed. The most typical example of slow VBA code is screen refresh. You can improve performance by temporarily suspending other event processing while the VBA code is running, and processing other events after the VBA code finishes executing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uc608\uc2dc_\ucf54\ub4dc\"><span class=\"ez-toc-section\" id=\"22_%EC%98%88%EC%8B%9C_%EC%BD%94%EB%93%9C\"><\/span>2.2. example code<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before entering the code to be processed, the global variable is set to a performance improvement value, and after the processing code is finished, it is changed to the original value. Please refer to the following code.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'\ucf54\ub4dc \uc9c4\uc785 \ubd80\ubd84\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\nApplication.EnableEvents = False\nApplication.DisplayAlerts = False\n\u00a0\n'\uc2e4\ud589\ud560 \ucf54\ub4dc\uac00 \ub4e4\uc5b4 \uac08 \ubd80\ubd84\n...\n\u00a0\n'\ucf54\ub4dc \uc885\ub8cc \ubd80\ubd84\nApplication.ScreenUpdating = True\nApplication.Calculation = xlCalculationAutomatic\nApplication.EnableEvents = True\nApplication.DisplayAlerts = True<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>Above, we looked at VBA coding patterns for performance improvement. If you have any questions, please leave a comment.<\/p>","protected":false},"excerpt":{"rendered":"<p>In this article, we will look at how to improve VBA performance. In the previous article, we compared the VBA Range Loop method and confirmed that the method using Variant Array is the fastest. VBA Coding Pattern: Range Loop - Read 1. Performance-Related VBA Global Variables Here is a summary of all variables....<\/p>","protected":false},"author":1,"featured_media":11628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[17,74,75,96],"class_list":["post-11627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-coding-pattern","tag-vba","tag-74","tag-codding-pattern","tag-96"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-26T08:30:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:07:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"345\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"},\"wordCount\":98,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"\ucf54\ub529\ud328\ud134\",\"Codding Pattern\",\"\uc131\ub2a5 \ud5a5\uc0c1\"],\"articleSection\":[\"\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\",\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"datePublished\":\"2022-09-26T08:30:05+00:00\",\"dateModified\":\"2022-10-04T14:07:30+00:00\",\"description\":\"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/image-179.png\",\"width\":802,\"height\":345},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/excel-vba-coding-pattern-performance-improvement\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Coding Patterns: Improving VBA Performance - Productivity Skills","description":"This article explores ways to improve Excel VBA performance. You&#039;ll learn about four VBA global variables that impact performance (ScreenUpdating, DisplayAlerts, Calculation, and EnableEvents), along with sample code.","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:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/","og_locale":"en_US","og_type":"article","og_title":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1 - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc5d1\uc140 VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc131\ub2a5\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 VBA \uc804\uc5ed \ubcc0\uc218 \ub124 \uac00\uc9c0(ScreenUpdating, DisplayAlerts, Calculation, EnableEvents)\uc640 \uc608\uc2dc \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/excel-vba-coding-pattern-performance-improvement\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-26T08:30:05+00:00","article_modified_time":"2022-10-04T14:07:30+00:00","og_image":[{"width":802,"height":345,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"},"wordCount":98,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","keywords":["\uc5d1\uc140VBA","\ucf54\ub529\ud328\ud134","Codding Pattern","\uc131\ub2a5 \ud5a5\uc0c1"],"articleSection":["\uc5d1\uc140 VBA \ucf54\ub529\ud328\ud134"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","url":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/","name":"VBA Coding Patterns: Improving VBA Performance - Productivity Skills","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","datePublished":"2022-09-26T08:30:05+00:00","dateModified":"2022-10-04T14:07:30+00:00","description":"This article explores ways to improve Excel VBA performance. You&#039;ll learn about four VBA global variables that impact performance (ScreenUpdating, DisplayAlerts, Calculation, and EnableEvents), along with sample code.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-179.png","width":802,"height":345},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-coding-pattern-performance-improvement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"VBA \ucf54\ub529 \ud328\ud134: VBA \uc131\ub2a5 \ud5a5\uc0c1"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11627"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11628"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}