{"id":660,"date":"2023-09-30T03:39:02","date_gmt":"2023-09-30T03:39:02","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/"},"modified":"2023-12-25T10:25:46","modified_gmt":"2023-12-25T10:25:46","slug":"insertar-una-columna","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/","title":{"rendered":"\u00bfc\u00f3mo insertar columnas usando vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1017135756\"><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>En este tutorial, veremos c\u00f3mo insertar una columna usando c\u00f3digo VBA en Excel. Tambi\u00e9n exploraremos cu\u00e1les son las diferentes formas de escribir una macro para esto.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar una sola columna usando VBA<\/strong><\/h2>\n<p> Para insertar una columna usando c\u00f3digo VBA, debe usar la propiedad \u00abColumna completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de columna completa, puede hacer referencia a toda la columna usando una celda y luego insertar una nueva columna. De forma predeterminada, insertar\u00e1 una columna antes de la celda que mencionaste. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54138\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"insertar una sola columna usando vba\" width=\"580\" height=\"279\"><\/figure>\n<\/div>\n<ol type=\"1\">\n<li> Primero, especifique una celda usando el objeto de rango.<\/li>\n<li> Ahora ingrese un punto (.) para obtener la lista de propiedades y m\u00e9todos.<\/li>\n<li> Despu\u00e9s de eso, seleccione la propiedad \u00abColumna completa\u00bb o escr\u00edbala.<\/li>\n<li> Al final, ingrese un punto (.) nuevamente y seleccione el m\u00e9todo \u201cInsertar\u201d o escr\u00edbalo.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").EntireColumn.Insert<\/code><\/pre>\n<p> Su c\u00f3digo est\u00e1 listo aqu\u00ed para insertar una columna. Ahora, cuando ejecuta este c\u00f3digo, inserta instant\u00e1neamente una nueva columna antes de la columna A.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar varias columnas<\/strong><\/h2>\n<p> Hay dos formas de insertar varias columnas en una hoja de c\u00e1lculo que he encontrado. El primero es el mismo m\u00e9todo de inserci\u00f3n que utilizamos en el ejemplo anterior. Con esto, debe especificar un rango de columnas cuyo n\u00famero sea igual al n\u00famero de la columna que desea insertar.<\/p>\n<p> Ahora suponga que desea insertar 5 columnas despu\u00e9s de la columna C en caso de que pueda usar un c\u00f3digo como este. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54139\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inserer-plusieurs-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"insertar varias columnas\" width=\"739\" height=\"301\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"C:G\").EntireColumn.Insert<\/code><\/pre>\n<p> Para ser honesto, no encontr\u00e9 este m\u00e9todo muy \u00fatil porque tienes que cambiar el rango si quieres cambiar el c\u00f3digo en s\u00ed. Entonces, aqu\u00ed est\u00e1 el segundo m\u00e9todo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">'variables to use in the code Dim iCol As Long Dim iCount As Long Dim i As Long 'to get the number of columns that you want to insert with an input box iCount = InputBox(Prompt:=\"How many column you want to add?\") 'to get the column number where you want to insert the new column iCol = InputBox _ (Prompt:= _ \"After which column you want to add new column? (Enter the column number)\") 'loop to insert new column(s) For i = 1 To iCount Columns(iCol).EntireColumn.Insert Next i<\/code><\/pre>\n<p> Cuando ejecuta este c\u00f3digo, le pide que ingrese la cantidad de columnas que desea agregar y luego el n\u00famero de columna donde desea agregar todas estas columnas nuevas. Utiliza un <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">bucle FOR (For Next)<\/a> para ingresar la cantidad de columnas que mencionaste.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar columnas basadas en valores de celda<\/strong><\/h2>\n<p> Si desea insertar columnas basadas en un valor de celda, puede utilizar el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim iCol As Long Dim iCount As Long Dim i As Long iCount = Range(\"A1\").Value iCol = Range(\"B1\").Value For i = 1 To iCount Columns(iCol).EntireColumn.Insert Next i<\/code><\/pre>\n<p> Cuando ejecuta esta macro, toma la cantidad de columnas de la celda A1 y la columna a la que desea agregar columnas de la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar una columna sin formato<\/strong><\/h2>\n<p> Cuando inserta una columna donde la columna de arriba tiene un formato espec\u00edfico, en ese caso la columna tambi\u00e9n tendr\u00e1 ese formato autom\u00e1ticamente. Y la forma m\u00e1s sencilla de gestionar esta situaci\u00f3n es utilizar formatos claros. Considere el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Columns(7).EntireColumn.Insert Columns(7).ClearFormats<\/code><\/pre>\n<p> Cuando ejecuta el c\u00f3digo anterior, inserta una nueva columna antes de la <sup>s\u00e9ptima<\/sup> columna. Ahora, lo que sucede es que cuando inserta una columna antes de la <sup>s\u00e9ptima<\/sup> columna, esta nueva columna se convierte en la <sup>s\u00e9ptima<\/sup> columna, luego la segunda l\u00ednea de c\u00f3digo borra los formatos.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar una columna copiada<\/strong><\/h2>\n<p> Tambi\u00e9n puedes utilizar el mismo m\u00e9todo para copiar una columna y luego insertarla en otro lugar. Vea el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.CutCopyMode = False With Worksheets(\"Data\") .Columns(5).Copy .Columns(9).Insert Shift:=xlShiftDown End With Application.CutCopyMode = True<\/code><\/pre>\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\"> Tutoriales relacionados <\/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\/numero-de-lineas\/\">Contar filas usando VBA en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fuente-de-caracteres\/\">Fuente Excel VBA (color, tama\u00f1o, tipo y negrita)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocultar-mostrar-fila-de-columna\/\">Excel VBA Ocultar y mostrar una columna o fila<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rango-1\/\">Rango de Excel VBA: trabajar con rango y celdas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fronteras\/\">Aplicar bordes a una celda usando VBA en Excel<\/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\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En este tutorial, veremos c\u00f3mo insertar una columna usando c\u00f3digo VBA en Excel. Tambi\u00e9n exploraremos cu\u00e1les son las diferentes formas de escribir una macro para esto. Insertar una sola columna usando VBA Para insertar una columna usando c\u00f3digo VBA, debe usar la propiedad \u00abColumna completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de columna completa, [&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-660","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 insertar columnas usando 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\/insertar-una-columna\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo insertar columnas usando vba?\" \/>\n<meta property=\"og:description\" content=\"En este tutorial, veremos c\u00f3mo insertar una columna usando c\u00f3digo VBA en Excel. Tambi\u00e9n exploraremos cu\u00e1les son las diferentes formas de escribir una macro para esto. Insertar una sola columna usando VBA Para insertar una columna usando c\u00f3digo VBA, debe usar la propiedad \u00abColumna completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de columna completa, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-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=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/\",\"name\":\"\u00bfc\u00f3mo insertar columnas usando vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png\",\"datePublished\":\"2023-09-30T03:39:02+00:00\",\"dateModified\":\"2023-12-25T10:25:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo insertar columnas usando 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 insertar columnas usando 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\/insertar-una-columna\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo insertar columnas usando vba?","og_description":"En este tutorial, veremos c\u00f3mo insertar una columna usando c\u00f3digo VBA en Excel. Tambi\u00e9n exploraremos cu\u00e1les son las diferentes formas de escribir una macro para esto. Insertar una sola columna usando VBA Para insertar una columna usando c\u00f3digo VBA, debe usar la propiedad \u00abColumna completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de columna completa, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/","url":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/","name":"\u00bfc\u00f3mo insertar columnas usando vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png","datePublished":"2023-09-30T03:39:02+00:00","dateModified":"2023-12-25T10:25:46+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/insertar-una-columna\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-colonne-en-utilisant-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/insertar-una-columna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo insertar columnas usando 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\/660","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=660"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/660\/revisions"}],"predecessor-version":[{"id":1100,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/660\/revisions\/1100"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}