{"id":76,"date":"2023-11-17T09:38:55","date_gmt":"2023-11-17T09:38:55","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/"},"modified":"2023-12-25T10:31:32","modified_gmt":"2023-12-25T10:31:32","slug":"rango-utilizado","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la propiedad usedrange en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-674743107\"><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 VBA, la propiedad UsedRange representa el rango de una hoja de trabajo que contiene datos. El rango utilizado comienza desde la primera celda de la hoja de trabajo donde tiene un valor hasta la \u00faltima celda donde tiene un valor. Al igual que en el siguiente ejemplo donde utiliz\u00f3 el rango de A1 a C11. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\" sizes=\"auto, \" srcset=\"\" alt=\"propiedad de rango utilizada\" width=\"521\" height=\"295\"><\/figure>\n<\/div>\n<p class=\"qt-tip\"> <strong>Nota: La propiedad UsedRange es una propiedad de solo lectura<\/strong> .<\/p>\n<h2 class=\"wp-block-heading\"> Escribir c\u00f3digo con UsedRange<\/h2>\n<p> Utilice el siguiente c\u00f3digo.<\/p>\n<ol type=\"1\">\n<li> Primero, debe especificar la hoja de c\u00e1lculo.<\/li>\n<li> Luego ingrese un punto (.) e ingrese \u00abUsedRange\u00bb.<\/li>\n<li> Despu\u00e9s de eso, use la propiedad o m\u00e9todo que desee usar.<\/li>\n<li> Al final, ejecute el c\u00f3digo.<\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Clear End Sub<\/code><\/pre>\n<p> El c\u00f3digo anterior borra todo del rango usado de la hoja activa.<\/p>\n<h2 class=\"wp-block-heading\"> Copiar el rango usado<\/h2>\n<p> Utilice el siguiente c\u00f3digo para copiar todo el UsedRange. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-toute-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"copiar todo el rango usado\" width=\"551\" height=\"410\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Copy End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar filas y columnas en el rango utilizado<\/h2>\n<p> Hay una propiedad de recuento que puede utilizar para contar las filas y columnas del rango utilizado.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveSheet.UsedRange.Rows.Count MsgBox ActiveSheet.UsedRange.Columns.Count<\/code><\/pre>\n<p> Las dos l\u00edneas de c\u00f3digo anteriores muestran un cuadro de mensaje con la cantidad de filas y columnas que tiene en el rango utilizado.<\/p>\n<h2 class=\"wp-block-heading\"> Activar la \u00faltima celda del rango utilizado<\/h2>\n<p> Tambi\u00e9n puede habilitar la \u00faltima celda del rango utilizado (esta ser\u00eda la \u00faltima celda utilizada en la hoja de trabajo). Considere el siguiente c\u00f3digo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53430\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-dernieres-cellules-actives-de-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00faltima celda activa del rango utilizado\" width=\"641\" height=\"403\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCol As Long Dim iRow As Long iRow = ActiveSheet.UsedRange.Rows.Count iCol = ActiveSheet.UsedRange.Columns.Count ActiveSheet.UsedRange.Select Selection.Cells(iRow, iCol).Select End Sub<\/code><\/pre>\n<p> Este c\u00f3digo toma el n\u00famero de filas y columnas usando la propiedad UsedRange y luego usa estos n\u00fameros para seleccionar la \u00faltima celda en el rango usado.<\/p>\n<h2 class=\"wp-block-heading\"> Consulte UsedRange en otra hoja de trabajo.<\/h2>\n<p> Si intenta hacer referencia al rango utilizado en una hoja de trabajo que no sea la hoja activa, VBA mostrar\u00e1 un error 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-53431\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-plage-utilisee-dans-une-autre-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"rango utilizado en otra hoja de trabajo\" width=\"465\" height=\"331\"><\/figure>\n<\/div>\n<p> Por lo tanto, la hoja de trabajo a la que hace referencia debe estar activada (solo entonces podr\u00e1 usar la propiedad UsedRange).<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Worksheets(\"Sheet4\").Activate Worksheets(\"Sheet4\").UsedRange.Select End Sub<\/code><\/pre>\n<p> Esto significa que no puede hacer referencia al rango utilizado en un libro cerrado. Pero primero puede abrir un libro de trabajo y luego habilitar la hoja de trabajo para usar la propiedad UsedRange.<\/p>\n<h2 class=\"wp-block-heading\"> Obtener la direcci\u00f3n del rango utilizado<\/h2>\n<p> Utilice la siguiente l\u00ednea de c\u00f3digo para obtener la direcci\u00f3n del rango utilizado.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() MsgBox ActiveSheet.UsedRange.Address End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Contar celdas vac\u00edas en el rango usado<\/h2>\n<p> El siguiente c\u00f3digo utiliza <a href=\"https:\/\/exceladvisor.org\/es\/para-el-bucle\/\">bucles FOR (For Each)<\/a> y recorre todas las celdas del rango utilizado y cuenta las celdas vac\u00edas.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCell As Range Dim iRange As Range Dim c As Long Dim i As Long Set iRange = ActiveSheet.UsedRange For Each iCell In ActiveSheet.UsedRange c = c + 1 If IsEmpty(iCell) = True Then i = i + 1 End If Next iCell MsgBox \"There are total \" &amp; c &amp; _ \" cell(s) in the range, and out of those \" &amp; _ i &amp; \" cell(s) are empty.\" End Sub<\/code><\/pre>\n<p> Cuando ejecuta este c\u00f3digo, muestra un <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">cuadro de mensaje<\/a> con el n\u00famero total de celdas y el n\u00famero de celdas vac\u00edas.<\/p>\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 VBA, la propiedad UsedRange representa el rango de una hoja de trabajo que contiene datos. El rango utilizado comienza desde la primera celda de la hoja de trabajo donde tiene un valor hasta la \u00faltima celda donde tiene un valor. Al igual que en el siguiente ejemplo donde utiliz\u00f3 el rango de A1 a [&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-76","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 utilizar la propiedad usedrange 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\/rango-utilizado\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la propiedad usedrange en vba?\" \/>\n<meta property=\"og:description\" content=\"En VBA, la propiedad UsedRange representa el rango de una hoja de trabajo que contiene datos. El rango utilizado comienza desde la primera celda de la hoja de trabajo donde tiene un valor hasta la \u00faltima celda donde tiene un valor. Al igual que en el siguiente ejemplo donde utiliz\u00f3 el rango de A1 a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:31:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.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\/rango-utilizado\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/\",\"name\":\"\u00bfc\u00f3mo utilizar la propiedad usedrange en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"datePublished\":\"2023-11-17T09:38:55+00:00\",\"dateModified\":\"2023-12-25T10:31:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la propiedad usedrange 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 utilizar la propiedad usedrange 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\/rango-utilizado\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la propiedad usedrange en vba?","og_description":"En VBA, la propiedad UsedRange representa el rango de una hoja de trabajo que contiene datos. El rango utilizado comienza desde la primera celda de la hoja de trabajo donde tiene un valor hasta la \u00faltima celda donde tiene un valor. Al igual que en el siguiente ejemplo donde utiliz\u00f3 el rango de A1 a [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:31:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.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\/rango-utilizado\/","url":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/","name":"\u00bfc\u00f3mo utilizar la propiedad usedrange en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","datePublished":"2023-11-17T09:38:55+00:00","dateModified":"2023-12-25T10:31:32+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/rango-utilizado\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/rango-utilizado\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la propiedad usedrange 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\/76","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=76"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/76\/revisions"}],"predecessor-version":[{"id":1366,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/76\/revisions\/1366"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}