{"id":222,"date":"2023-11-11T08:48:18","date_gmt":"2023-11-11T08:48:18","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/"},"modified":"2023-12-25T10:25:58","modified_gmt":"2023-12-25T10:25:58","slug":"insertar-una-linea-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/","title":{"rendered":"\u00bfc\u00f3mo insertar una fila usando vba en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3068786344\"><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 fila o 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 fila usando VBA<\/strong><\/h2>\n<p> Para insertar una fila usando c\u00f3digo VBA, debe usar la propiedad \u00abFila completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de fila completa, puede hacer referencia a la fila completa usando una celda y luego insertar una nueva fila all\u00ed. De forma predeterminada, insertar\u00e1 una sola fila 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-54129\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"insertar una sola l\u00ednea usando vba\" width=\"583\" height=\"317\"><\/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 \u00abFila completa\u00bb o ingr\u00e9sela.<\/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\").EntireRow.Insert<\/code><\/pre>\n<p> Su c\u00f3digo est\u00e1 listo aqu\u00ed para insertar una l\u00ednea. Ahora, cuando ejecuta este c\u00f3digo, instant\u00e1neamente inserta una nueva fila antes de la celda A1.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar varias l\u00edneas<\/strong><\/h2>\n<p> Hay dos formas de insertar varias filas en una hoja de c\u00e1lculo que encontr\u00e9. El primero es el mismo m\u00e9todo de inserci\u00f3n que utilizamos en el ejemplo anterior.<\/p>\n<p> Con esto, debes especificar un rango cuyo n\u00famero sea equivalente al n\u00famero de filas que deseas insertar. Ahora suponga que desea insertar 5 l\u00edneas despu\u00e9s, en este caso puede 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-54130\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inserer-plusieurs-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"insertar varias l\u00edneas\" width=\"608\" height=\"342\"><\/figure>\n<\/div>\n<p> Para ser honesto, este m\u00e9todo no me pareci\u00f3 muy \u00fatil porque tienes que cambiar el rango si quieres cambiar el n\u00famero de filas.<\/p>\n<p> As\u00ed que aqu\u00ed est\u00e1 el segundo m\u00e9todo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim iRow As Long Dim iCount As Long Dim i As Long iCount = InputBox(Prompt:=\"How many rows you want to add?\") iRow = InputBox _ (Prompt:=\"After which row you want to add new rows? (Enter the row number\") For i = 1 To iCount Rows(iRow).EntireRow.Insert Next i<\/code><\/pre>\n<p> Cuando ejecuta este c\u00f3digo, le pide que ingrese la cantidad de l\u00edneas que desea agregar y luego el n\u00famero de l\u00ednea donde desea agregar todas estas l\u00edneas. Utiliza un <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">bucle FOR (For Next)<\/a> para repetir este n\u00famero de veces e insertar filas una por una.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar filas seg\u00fan los valores de las celdas<\/strong><\/h2>\n<p> Si desea insertar filas seg\u00fan el <a href=\"https:\/\/exceladvisor.org\/es\/valor-de-celda\/\">valor de una celda<\/a> , puede utilizar el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim iRow As Long Dim iCount As Long Dim i As Long iCount = Range(\"A1\").Value iRow = Range(\"B1\").Value For i = 1 To iCount Rows(iRow).EntireRow.Insert Next i<\/code><\/pre>\n<p> Cuando ejecuta esta macro, toma la cantidad de filas de la celda A1 y la fila donde desea agregar filas de la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar una l\u00ednea sin formatear<\/strong><\/h2>\n<p> Cuando inserta una fila donde la fila de arriba tiene un formato espec\u00edfico, en este caso la fila tambi\u00e9n tendr\u00e1 ese formato autom\u00e1ticamente. Y la forma m\u00e1s sencilla de gestionar esta situaci\u00f3n es utilizar <a href=\"https:\/\/exceladvisor.org\/es\/contenido-claro-1\/\">formatos claros<\/a> . Considere el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Rows(7).EntireRow.Insert Rows(7).ClearFormats<\/code><\/pre>\n<p> Cuando ejecuta el c\u00f3digo anterior, inserta una nueva l\u00ednea antes de la <sup>s\u00e9ptima<\/sup> l\u00ednea. Ahora, \u00bfqu\u00e9 sucede? Cuando insertas una l\u00ednea antes de la <sup>s\u00e9ptima<\/sup> l\u00ednea, esa nueva l\u00ednea se convierte en la <sup>s\u00e9ptima<\/sup> l\u00ednea, luego la segunda l\u00ednea de c\u00f3digo borra los formatos de esa l\u00ednea.<\/p>\n<h2 class=\"wp-block-heading\"> <strong>Insertar una l\u00ednea copiada<\/strong><\/h2>\n<p> Tambi\u00e9n puedes utilizar el mismo m\u00e9todo para copiar una l\u00ednea 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\") .Rows(5).Copy .Rows(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 fila o 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 fila usando VBA Para insertar una fila usando c\u00f3digo VBA, debe usar la propiedad \u00abFila completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de [&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-222","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 una fila usando vba en excel?<\/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-linea-1\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo insertar una fila usando vba en excel?\" \/>\n<meta property=\"og:description\" content=\"En este tutorial, veremos c\u00f3mo insertar una fila o 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 fila usando VBA Para insertar una fila usando c\u00f3digo VBA, debe usar la propiedad \u00abFila completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-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-linea-1\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/\",\"name\":\"\u00bfc\u00f3mo insertar una fila usando vba en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png\",\"datePublished\":\"2023-11-11T08:48:18+00:00\",\"dateModified\":\"2023-12-25T10:25:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo insertar una fila usando vba en excel?\"}]},{\"@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 una fila usando vba en excel?","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-linea-1\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo insertar una fila usando vba en excel?","og_description":"En este tutorial, veremos c\u00f3mo insertar una fila o 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 fila usando VBA Para insertar una fila usando c\u00f3digo VBA, debe usar la propiedad \u00abFila completa\u00bb con el m\u00e9todo \u00abInsertar\u00bb. Con la propiedad de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-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-linea-1\/","url":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/","name":"\u00bfc\u00f3mo insertar una fila usando vba en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png","datePublished":"2023-11-11T08:48:18+00:00","dateModified":"2023-12-25T10:25:58+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-inserer-une-seule-ligne-en-utilisant-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/insertar-una-linea-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo insertar una fila usando vba en excel?"}]},{"@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\/222","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=222"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/222\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/222\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}