{"id":57,"date":"2023-11-17T19:29:27","date_gmt":"2023-11-17T19:29:27","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/"},"modified":"2023-12-25T10:23:41","modified_gmt":"2023-12-25T10:23:41","slug":"borrar-la-pizarra","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/","title":{"rendered":"\u00bfc\u00f3mo borrar una tabla en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-738323436\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Debe utilizar la instrucci\u00f3n \u00abBorrar\u00bb para borrar una matriz en VBA. Agregue la palabra clave \u00abBorrar\u00bb antes del nombre de la tabla que desea borrar, pero tenga en cuenta que todos los valores se restablecer\u00e1n de la tabla. En la siguiente tabla tiene 3 elementos y usamos la declaraci\u00f3n de borrado para borrar todo. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro1() Dim myArray() As Long ReDim myArray(4) myArray(1) = 1 myArray(2) = 2 myArray(3) = 3 myArray(4) = 4 ReDim myArray(1 To 5) MsgBox myArray(3) End Sub<\/code> <\/pre>\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57463\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-clear-array\" width=\"732\" height=\"419\"><\/figure>\n<\/div>\n<p> Y con esta declaraci\u00f3n, borr\u00f3 todos los elementos de la matriz, y cuando usamos <a href=\"https:\/\/exceladvisor.org\/es\/impresion-de-depuracion-inmediata-de-ventana\/\">Debug.Print (Ventana Inmediata)<\/a> para obtener el elemento de la matriz, no queda nada.<\/p>\n<h2 class=\"wp-block-heading\"> Borrar tabla din\u00e1mica<\/h2>\n<p> Cuando usas ReDim, elimina todos los elementos. Pero puedes usar la declaraci\u00f3n preserve para preservar algunos de los elementos y borrar parcialmente una matriz. En el siguiente ejemplo, tenemos una matriz y borramos parcialmente el cuarto valor y luego establecimos los elementos nuevamente en 5.<\/p>\n<p> Y si desea borrar parcialmente una matriz din\u00e1mica.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro2() Dim myArray() As Long ReDim myArray(1 To 4) myArray(1) = 1 myArray(2) = 2 myArray(3) = 3 myArray(4) = 4 'erase position 4 but preserve the 1,2, and 3 ReDim Preserve myArray(1 To 3) 'redefine the array items to five ReDim Preserve myArray(1 To 5) MsgBox myArray(3) End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> <strong>Puntos importantes<\/strong><\/h2>\n<ol type=\"1\">\n<li> Cuando borras una mesa fija:\n<ol>\n<li> En una matriz que contiene todos los valores de una cadena, la instrucci\u00f3n de borrado restablecer\u00e1 todos los elementos en (longitud variable) a la cadena de longitud cero \u00bb \u00bb y (longitud fija) a cero.<\/li>\n<li> En una matriz que contiene valores num\u00e9ricos, la instrucci\u00f3n de borrado restablecer\u00e1 todos los elementos a cero.<\/li>\n<li> En una matriz que, como tipo de datos variable, las declaraciones claras restablecer\u00e1n todos los elementos al estado vac\u00edo.<\/li>\n<li> En una matriz que contiene objetos, la instrucci\u00f3n de borrado restablecer\u00e1 todos los elementos a nada.<\/li>\n<li> En una matriz que contiene objetos, la instrucci\u00f3n de borrado restablecer\u00e1 todos los elementos si fuera una variable separada.<\/li>\n<\/ol>\n<\/li>\n<li> Cuando borra una matriz din\u00e1mica, la instrucci\u00f3n de borrado libera el espacio utilizado por la matriz din\u00e1mica.<\/li>\n<\/ol>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Obtenga m\u00e1s informaci\u00f3n sobre <a href=\"https:\/\/exceladvisor.org\/es\/pinturas\/\">las tablas VBA<\/a> <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-nueva-matriz-de-valores\/\">VBA Agregar nuevo valor a la matriz<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tamano-de-matriz\/\">Longitud de la matriz VBA (tama\u00f1o)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mesa-con-cadenas\/\">Matriz VBA con cadenas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/tabla-dinamica\/\">Tabla din\u00e1mica VBA<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/matriz-de-bucle-vba\/\">Bucle de VBA en una matriz<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/matriz-multidimensional\/\">Matriz multidimensional VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/la-playa-tiene-una-pintura\/\">rango de VBA a una matriz<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mesa-de-clasificacion\/\">tabla de salida de VBA<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Debe utilizar la instrucci\u00f3n \u00abBorrar\u00bb para borrar una matriz en VBA. Agregue la palabra clave \u00abBorrar\u00bb antes del nombre de la tabla que desea borrar, pero tenga en cuenta que todos los valores se restablecer\u00e1n de la tabla. En la siguiente tabla tiene 3 elementos y usamos la declaraci\u00f3n de borrado para borrar todo. Sub [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-57","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo borrar una tabla en vba?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo borrar una tabla en vba?\" \/>\n<meta property=\"og:description\" content=\"Debe utilizar la instrucci\u00f3n \u00abBorrar\u00bb para borrar una matriz en VBA. Agregue la palabra clave \u00abBorrar\u00bb antes del nombre de la tabla que desea borrar, pero tenga en cuenta que todos los valores se restablecer\u00e1n de la tabla. En la siguiente tabla tiene 3 elementos y usamos la declaraci\u00f3n de borrado para borrar todo. Sub [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\",\"name\":\"\u00bfc\u00f3mo borrar una tabla en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\",\"datePublished\":\"2023-11-17T19:29:27+00:00\",\"dateModified\":\"2023-12-25T10:23:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo borrar una tabla en vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo borrar una tabla en 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:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo borrar una tabla en vba?","og_description":"Debe utilizar la instrucci\u00f3n \u00abBorrar\u00bb para borrar una matriz en VBA. Agregue la palabra clave \u00abBorrar\u00bb antes del nombre de la tabla que desea borrar, pero tenga en cuenta que todos los valores se restablecer\u00e1n de la tabla. En la siguiente tabla tiene 3 elementos y usamos la declaraci\u00f3n de borrado para borrar todo. Sub [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/","url":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/","name":"\u00bfc\u00f3mo borrar una tabla en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png","datePublished":"2023-11-17T19:29:27+00:00","dateModified":"2023-12-25T10:23:41+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-clair-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/borrar-la-pizarra\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo borrar una tabla en vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/57\/revisions"}],"predecessor-version":[{"id":864,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/57\/revisions\/864"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}