{"id":821,"date":"2019-10-22T18:29:18","date_gmt":"2019-10-22T18:29:18","guid":{"rendered":"http:\/\/smartcodebuilders.com\/wp\/?p=821"},"modified":"2024-11-01T02:29:36","modified_gmt":"2024-11-01T02:29:36","slug":"loops-en-vba","status":"publish","type":"post","link":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/","title":{"rendered":"Bucles en VBA: Optimiza tu Programaci\u00f3n"},"content":{"rendered":"<p>Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o <em>loops<\/em> son fundamentales en la programaci\u00f3n, y entender su funcionamiento te permitir\u00e1 crear programas m\u00e1s eficientes.<\/p>\n<h2>\u00bfQu\u00e9 es un bucle en programaci\u00f3n?<\/h2>\n<p>Un <em>loop<\/em> es la repetici\u00f3n c\u00edclica de una actividad, limitada a un n\u00famero finito de repeticiones. Un bucle se puede interrumpir al alcanzar el n\u00famero establecido de repeticiones o al cumplirse una condici\u00f3n espec\u00edfica. Para m\u00e1s informaci\u00f3n sobre condicionales, revisa nuestro tutorial sobre <a href=\"http:\/\/smartcodebuilders.com\/wp\/condicionales-en-vba-if-elseif-else-end-if\/\">Condicionales en VBA<\/a>.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"323\" height=\"338\" class=\"wp-image-824\" src=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\" alt=\"Definici\u00f3n de un Loop en programaci\u00f3n\" srcset=\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png 323w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9-287x300.png 287w\" sizes=\"auto, (max-width: 323px) 100vw, 323px\" \/><figcaption>Figura 1. Definici\u00f3n de un Loop en programaci\u00f3n.<\/figcaption><\/figure>\n<\/div>\n<h2>Tipos de bucles en VBA<\/h2>\n<p>En VBA, existen dos estructuras principales para implementar bucles: <strong>For \/ Next<\/strong> y <strong>Do \/ Loop<\/strong>. Cada una tiene caracter\u00edsticas \u00fanicas que la hacen adecuada para diferentes situaciones. A continuaci\u00f3n, exploraremos ambos tipos con ejemplos pr\u00e1cticos.<\/p>\n<h2>Estructura For Next<\/h2>\n<p>La estructura <strong>For Next<\/strong> permite realizar una acci\u00f3n repetitiva desde un n\u00famero inicial (NI) hasta un n\u00famero final (NF). A continuaci\u00f3n, se muestra un ejemplo de c\u00f3mo se puede estructurar un bucle <strong>For<\/strong>:<\/p>\n<figure class=\"wp-block-table\">\n<table>\n<tbody>\n<tr>\n<td><strong>NI<\/strong><\/td>\n<td><strong>NF<\/strong><\/td>\n<td><strong>Total de repeticiones<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>10<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>19<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>81<\/td>\n<td>91<\/td>\n<td>10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>El n\u00famero de repeticiones debe ser un entero. La estructura <strong>For Next<\/strong> se declara de la siguiente manera:<\/p>\n<figure class=\"wp-block-table is-style-regular\">\n<table>\n<tbody>\n<tr>\n<td><strong>For<\/strong> Variable = NI <strong>To<\/strong> NF <strong>Step<\/strong> incremento<\/td>\n<td>Declaraci\u00f3n del lazo<\/td>\n<\/tr>\n<tr>\n<td>Actividad repetitiva<\/td>\n<td>Actividad<\/td>\n<\/tr>\n<tr>\n<td><strong>Next<\/strong><\/td>\n<td>Declaraci\u00f3n del lazo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h3>Ejemplo del bucle For Next en VBA<\/h3>\n<p>A continuaci\u00f3n, veremos c\u00f3mo encontrar la \u00faltima celda ocupada en un rango utilizando un bucle <strong>For Next<\/strong>:<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"348\" class=\"wp-image-846\" src=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/Fig-2-Estructura-For-Next-Editada-1.jpg\" alt=\"Ejemplo estructura For Next\" srcset=\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/Fig-2-Estructura-For-Next-Editada-1.jpg 653w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/Fig-2-Estructura-For-Next-Editada-1-600x320.jpg 600w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/Fig-2-Estructura-For-Next-Editada-1-300x160.jpg 300w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><figcaption>Figura 2. Ejemplo de la estructura For Next.<\/figcaption><\/figure>\n<pre class=\"wp-block-preformatted\"><code>Sub Tutorial5a_Loops()\r\nFor i = 1 To 10\r\n  If Cells(i + 1, 1) = \"\" Then\r\n    Ultima_fila = i \r\n    Exit For\r\n  End If\r\nNext\r\nMsgBox (\"\u00daltima fila: \" &amp; Ultima_fila)\r\nEnd Sub<\/code><\/pre>\n<p>En este c\u00f3digo, el programa verifica si la celda est\u00e1 vac\u00eda, y si es as\u00ed, se detiene y muestra la \u00faltima fila ocupada.<\/p>\n<h2>Estructura Do Loop<\/h2>\n<p>La estructura <strong>Do Loop<\/strong> no incrementa autom\u00e1ticamente la variable de repetici\u00f3n. Ofrece tres modalidades que permiten un control m\u00e1s flexible:<\/p>\n<h3>Modalidad Do<\/h3>\n<p>Esta forma permite declarar el bucle y especificar la condici\u00f3n de salida. Debe usarse con precauci\u00f3n para evitar bucles infinitos.<\/p>\n<figure class=\"wp-block-table is-style-regular\">\n<table>\n<tbody>\n<tr>\n<td><strong>Do<\/strong><\/td>\n<td>Declaraci\u00f3n del lazo<\/td>\n<\/tr>\n<tr>\n<td>Actividad repetitiva<\/td>\n<td>Actividad<\/td>\n<\/tr>\n<tr>\n<td>Variable=Variable+1<\/td>\n<td>Control del n\u00famero de repetici\u00f3n<\/td>\n<\/tr>\n<tr>\n<td><strong>Loop<\/strong><\/td>\n<td>Declaraci\u00f3n del lazo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<h4>Ejemplo del bucle Do Loop en VBA<\/h4>\n<p>El siguiente ejemplo muestra c\u00f3mo encontrar la \u00faltima fila ocupada utilizando <strong>Do Loop<\/strong>:<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"279\" class=\"wp-image-852\" src=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-11.png\" alt=\"Ejemplo estructura Do\" srcset=\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-11.png 416w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-11-300x201.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><figcaption>Figura 3. Ejemplo de la estructura Do.<\/figcaption><\/figure>\n<pre class=\"wp-block-preformatted\"><code>Sub Tutorial5b_Loops()\r\ni = 2\r\nDo\r\n  If Cells(i, 1) = \"\" Then\r\n    Ultima_fila = i - 1\r\n    Exit Do\r\n  End If\r\n  i = i + 1\r\nLoop\r\nMsgBox (\"\u00daltima fila: \" &amp; Ultima_fila)\r\nEnd Sub<\/code><\/pre>\n<h3>Modalidad Do While<\/h3>\n<p>Esta modalidad se ejecuta mientras se cumpla una condici\u00f3n especificada. Veamos c\u00f3mo aplicarla:<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"292\" class=\"wp-image-855\" src=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-12.png\" alt=\"Estructura Do While\" srcset=\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-12.png 435w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-12-300x201.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><figcaption>Figura 4. Estructura Do While.<\/figcaption><\/figure>\n<pre class=\"wp-block-preformatted\"><code>Sub Tutorial5c_Loops()\r\ni = 2\r\nDo While Cells(i, 1) &lt;&gt; \"\"\r\n  'Actividad repetitiva\r\n  i = i + 1\r\nLoop\r\nUltima_fila = i - 1\r\nMsgBox (\"\u00daltima fila: \" &amp; Ultima_fila)\r\nEnd Sub<\/code><\/pre>\n<h3>Modalidad Do Until<\/h3>\n<p>Esta modalidad se ejecuta hasta que se cumpla una condici\u00f3n. Aqu\u00ed hay un ejemplo:<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"278\" class=\"wp-image-864\" src=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-13.png\" alt=\"Ejemplo estructura Do Until\" srcset=\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-13.png 435w, https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-13-300x192.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><figcaption>Figura 5. Ejemplo de la estructura Do Until.<\/figcaption><\/figure>\n<pre class=\"wp-block-preformatted\"><code>Sub Tutorial5d_Loops()\r\ni = 2\r\nDo Until Cells(i, 1) = \"\"\r\n  'Actividad repetitiva\r\n  i = i + 1\r\nLoop\r\nUltima_fila = i - 1\r\nMsgBox (\"\u00daltima fila: \" &amp; Ultima_fila)\r\nEnd Sub<\/code><\/pre>\n<p>Como puedes ver, el bucle se ejecuta <strong>hasta<\/strong> encontrar la primera celda vac\u00eda.<\/p>\n<h2>Conclusi\u00f3n<\/h2>\n<p>Con lo aprendido en este tutorial, podr\u00e1s utilizar las estructuras de bucles en VBA sin dificultad. Se recomienda evitar la modalidad <strong>Do<\/strong> por el riesgo de bucles infinitos. Opta por <strong>For Next<\/strong>, <strong>Do While<\/strong> o <strong>Do Until<\/strong> para un control m\u00e1s seguro y efectivo.<\/p>\n<p>\u00bfQuieres saber m\u00e1s? <a href=\"https:\/\/smartcodebuilders.com\/wp\/contact-us\/\">Cont\u00e1ctanos&#8230;<\/a><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la programaci\u00f3n, y entender su funcionamiento te permitir\u00e1 crear programas m\u00e1s eficientes. \u00bfQu\u00e9 es un bucle<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[39,47,41],"tags":[],"class_list":["post-821","post","type-post","status-publish","format-standard","hentry","category-aprende-a-programar","category-excel","category-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders<\/title>\n<meta name=\"description\" content=\"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders\" \/>\n<meta property=\"og:description\" content=\"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la\" \/>\n<meta property=\"og:url\" content=\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"SmartCode Builders\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-22T18:29:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-01T02:29:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\" \/>\n<meta name=\"author\" content=\"SmartCoder1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"SmartCoder1\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\"},\"author\":{\"name\":\"SmartCoder1\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/69eae8c52989c036ac530e98038bd425\"},\"headline\":\"Bucles en VBA: Optimiza tu Programaci\u00f3n\",\"datePublished\":\"2019-10-22T18:29:18+00:00\",\"dateModified\":\"2024-11-01T02:29:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\"},\"wordCount\":514,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#organization\"},\"image\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\",\"articleSection\":[\"Aprende a Programar\",\"Excel\",\"VBA\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\",\"url\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\",\"name\":\"\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders\",\"isPartOf\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\",\"datePublished\":\"2019-10-22T18:29:18+00:00\",\"dateModified\":\"2024-11-01T02:29:36+00:00\",\"description\":\"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la\",\"breadcrumb\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage\",\"url\":\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\",\"contentUrl\":\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png\",\"width\":323,\"height\":338},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/smartcodebuilders.com\/wp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bucles en VBA: Optimiza tu Programaci\u00f3n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#website\",\"url\":\"https:\/\/smartcodebuilders.com\/wp\/\",\"name\":\"SmartCode Builders\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/smartcodebuilders.com\/wp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#organization\",\"name\":\"SmartCode Builders\",\"url\":\"https:\/\/smartcodebuilders.com\/wp\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/07\/cropped-SMARTCODE-LOGO-1-e1562625920666.png\",\"contentUrl\":\"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/07\/cropped-SMARTCODE-LOGO-1-e1562625920666.png\",\"width\":218,\"height\":76,\"caption\":\"SmartCode Builders\"},\"image\":{\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/69eae8c52989c036ac530e98038bd425\",\"name\":\"SmartCoder1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/754cb843d5ddcb71330d0e77d64203fb?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/754cb843d5ddcb71330d0e77d64203fb?s=96&d=mm&r=g\",\"caption\":\"SmartCoder1\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders","description":"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la","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:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/","og_locale":"es_ES","og_type":"article","og_title":"\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders","og_description":"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la","og_url":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/","og_site_name":"SmartCode Builders","article_published_time":"2019-10-22T18:29:18+00:00","article_modified_time":"2024-11-01T02:29:36+00:00","og_image":[{"url":"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png","type":"","width":"","height":""}],"author":"SmartCoder1","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"SmartCoder1","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#article","isPartOf":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/"},"author":{"name":"SmartCoder1","@id":"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/69eae8c52989c036ac530e98038bd425"},"headline":"Bucles en VBA: Optimiza tu Programaci\u00f3n","datePublished":"2019-10-22T18:29:18+00:00","dateModified":"2024-11-01T02:29:36+00:00","mainEntityOfPage":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/"},"wordCount":514,"commentCount":0,"publisher":{"@id":"https:\/\/smartcodebuilders.com\/wp\/#organization"},"image":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png","articleSection":["Aprende a Programar","Excel","VBA"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/","url":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/","name":"\u25b7Bucles en VBA: Optimiza tu Programaci\u00f3n - SmartCode Builders","isPartOf":{"@id":"https:\/\/smartcodebuilders.com\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage"},"image":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png","datePublished":"2019-10-22T18:29:18+00:00","dateModified":"2024-11-01T02:29:36+00:00","description":"Este tutorial es esencial para comprender c\u00f3mo los bucles en VBA pueden simplificar tus tareas en Excel. Los lazos o loops son fundamentales en la","breadcrumb":{"@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#primaryimage","url":"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png","contentUrl":"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/10\/image-9.png","width":323,"height":338},{"@type":"BreadcrumbList","@id":"https:\/\/smartcodebuilders.com\/wp\/loops-en-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/smartcodebuilders.com\/wp\/"},{"@type":"ListItem","position":2,"name":"Bucles en VBA: Optimiza tu Programaci\u00f3n"}]},{"@type":"WebSite","@id":"https:\/\/smartcodebuilders.com\/wp\/#website","url":"https:\/\/smartcodebuilders.com\/wp\/","name":"SmartCode Builders","description":"","publisher":{"@id":"https:\/\/smartcodebuilders.com\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/smartcodebuilders.com\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/smartcodebuilders.com\/wp\/#organization","name":"SmartCode Builders","url":"https:\/\/smartcodebuilders.com\/wp\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/07\/cropped-SMARTCODE-LOGO-1-e1562625920666.png","contentUrl":"https:\/\/smartcodebuilders.com\/wp\/wp-content\/uploads\/2019\/07\/cropped-SMARTCODE-LOGO-1-e1562625920666.png","width":218,"height":76,"caption":"SmartCode Builders"},"image":{"@id":"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/69eae8c52989c036ac530e98038bd425","name":"SmartCoder1","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/smartcodebuilders.com\/wp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/754cb843d5ddcb71330d0e77d64203fb?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/754cb843d5ddcb71330d0e77d64203fb?s=96&d=mm&r=g","caption":"SmartCoder1"}}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/posts\/821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/comments?post=821"}],"version-history":[{"count":69,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/posts\/821\/revisions"}],"predecessor-version":[{"id":1645,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/posts\/821\/revisions\/1645"}],"wp:attachment":[{"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/media?parent=821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/categories?post=821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartcodebuilders.com\/wp\/wp-json\/wp\/v2\/tags?post=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}