{"id":77,"date":"2023-11-17T09:32:12","date_gmt":"2023-11-17T09:32:12","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/rango-variable\/"},"modified":"2023-12-25T10:27:52","modified_gmt":"2023-12-25T10:27:52","slug":"rango-variable","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/rango-variable\/","title":{"rendered":"\u00bfc\u00f3mo usar una celda como variable en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3671460852\"><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>Para utilizar un rango o una sola celda como variable, primero debe declarar esa variable con el tipo de datos de rango. Una vez que haya hecho eso, debe especificar un rango desde una celda hasta esta variable usando el objeto de rango. Esto tambi\u00e9n le brinda acceso a todas las propiedades y m\u00e9todos que puede usar con un rango.<\/p>\n<ol type=\"1\">\n<li> Utilice la palabra clave \u00abDim\u00bb e ingrese el nombre de la variable.<\/li>\n<li> Declare la palabra clave como <a href=\"https:\/\/exceladvisor.org\/es\/rango-1\/\">Range<\/a> .<\/li>\n<li> Escriba el nombre de la variable.<\/li>\n<li> Especifique el rango que desea asignar a la variable. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53824\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\" sizes=\"auto, \" srcset=\"\" alt=\"usa la palabra clave tenue\" width=\"355\" height=\"264\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Establecer la selecci\u00f3n en variable de rango<\/h2>\n<p> Tambi\u00e9n puede usar el rango seleccionado para una variable y luego usar esa variable para acceder a propiedades y m\u00e9todos. Considere el siguiente c\u00f3digo.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Selection Selection.Clear End Sub<\/code><\/pre>\n<p> Pero hay una cosa con la que debes tener cuidado: cuando <a href=\"https:\/\/exceladvisor.org\/es\/objetos\/\">seleccionas un objeto<\/a> que no sea un rango, VBA te mostrar\u00e1 un error. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53825\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selection-dun-objet-autre-que-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"seleccionar un objeto distinto del rango\" width=\"580\" height=\"384\"><\/figure>\n<\/div>\n<p> Pero tambi\u00e9n es un m\u00e9todo din\u00e1mico en el que no es necesario cambiar el rango una y otra vez.<\/p>\n<h2 class=\"wp-block-heading\"> Copiar un rango usando una variable<\/h2>\n<p> Una vez que <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">declara una variable<\/a> como un rango, tambi\u00e9n puede copiar ese rango usando el nombre de esa variable. Supongamos que ha declarado el rango A1:A10 como variable rng (ejemplo anterior), puede copiarlo usando 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-53826\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copier-la-plage-en-utilisant-la-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"copiar organizar usando una variable\" width=\"567\" height=\"309\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Range(\"A1:A10\") rng.Copy End Sub<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Usando la variable de rango en una funci\u00f3n<\/h2>\n<p> Tambi\u00e9n puede utilizar una variable de rango para hacer referencia a un rango en una funci\u00f3n al escribir una macro. Considere el siguiente c\u00f3digo. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim iNames As Variant Dim rng As Range Set rng = Range(\"A1:A10\") Range(\"B1\") = WorksheetFunction.Max(rng) End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-plage-dutilisation-disponible-dans-une-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar una variable de rango en una funci\u00f3n\" width=\"546\" height=\"312\"><\/figure>\n<\/div>\n<p> Toma valores en el rango A1:A10 y como necesita usar la variable \u00abrng\u00bb, usamos la variable en el valor m\u00e1ximo para generarla.<\/p>\n<p> <strong>Relacionado:<\/strong> <a href=\"https:\/\/exceladvisor.org\/es\/funcion-de-hoja-de-calculo\/\">C\u00f3mo utilizar la funci\u00f3n de hoja de trabajo en VBA<\/a><\/p>\n<h2 class=\"wp-block-heading\"> Cuente el n\u00famero de filas y columnas.<\/h2>\n<p> Como dije antes, una vez que especificas una variable como rango, tambi\u00e9n obtendr\u00e1s todas las propiedades y m\u00e9todos de acceso. Imag\u00ednese si quisiera contar filas y columnas. Aqu\u00ed est\u00e1 el c\u00f3digo que podr\u00eda usarse. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_range_variable() Dim rng As Range Set rng = Range(\"A1:A10\") MsgBox \"This range has \" &amp; _ rng.Rows.Count &amp; \" row(s) and \" &amp; _ rng.Columns.Count &amp; \" coulmn(s).\" End Sub<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-compter-le-nombre-de-lignes-et-de-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar el n\u00famero de filas y columnas\" width=\"464\" height=\"388\"><\/figure>\n<\/div>\n<p> Cuando ejecuta este c\u00f3digo, <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensajes-vba\/\">muestra un mensaje<\/a> con el n\u00famero de filas y columnas en el rango que especific\u00f3 en la variable.<\/p>\n<h2 class=\"wp-block-heading\"> Definici\u00f3n de hoja de trabajo con rango<\/h2>\n<p> En todos los ejemplos anteriores, usamos el rango sin mencionar la hoja de trabajo, por lo que cuando ejecute este c\u00f3digo, VBA siempre har\u00e1 referencia al rango en la hoja activa. Pero si desea hacer referencia a una hoja de trabajo espec\u00edfica, debe usar el <a href=\"https:\/\/exceladvisor.org\/es\/hoja-de-trabajo-1\/\">objeto de la hoja de trabajo<\/a> con el rango.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim rng As Range Set rng = Worksheets(\"Sheet1\").Range(\"A1:A10\")<\/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\/variable-global\/\">Declarar una variable global (p\u00fablica) en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/opcion-explicita-2\/\">Declaraci\u00f3n de opci\u00f3n expl\u00edcita en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cuadro-de-mensaje-variable\/\">Variable en un cuadro de mensaje<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/constantes\/\">VBA constante<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/debil\/\">Instrucci\u00f3n VBA tenue<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/variables\/\">Variables de VBA (declaraci\u00f3n, tipos de datos y alcance)<\/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>Para utilizar un rango o una sola celda como variable, primero debe declarar esa variable con el tipo de datos de rango. Una vez que haya hecho eso, debe especificar un rango desde una celda hasta esta variable usando el objeto de rango. Esto tambi\u00e9n le brinda acceso a todas las propiedades y m\u00e9todos que [&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-77","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 usar una celda como variable 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-variable\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo usar una celda como variable en vba?\" \/>\n<meta property=\"og:description\" content=\"Para utilizar un rango o una sola celda como variable, primero debe declarar esa variable con el tipo de datos de rango. Una vez que haya hecho eso, debe especificar un rango desde una celda hasta esta variable usando el objeto de rango. Esto tambi\u00e9n le brinda acceso a todas las propiedades y m\u00e9todos que [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/rango-variable\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.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-variable\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/\",\"name\":\"\u00bfc\u00f3mo usar una celda como variable en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\",\"datePublished\":\"2023-11-17T09:32:12+00:00\",\"dateModified\":\"2023-12-25T10:27:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/rango-variable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango-variable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo usar una celda como variable 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 usar una celda como variable 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-variable\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo usar una celda como variable en vba?","og_description":"Para utilizar un rango o una sola celda como variable, primero debe declarar esa variable con el tipo de datos de rango. Una vez que haya hecho eso, debe especificar un rango desde una celda hasta esta variable usando el objeto de rango. Esto tambi\u00e9n le brinda acceso a todas las propiedades y m\u00e9todos que [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/rango-variable\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.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-variable\/","url":"https:\/\/exceladvisor.org\/es\/rango-variable\/","name":"\u00bfc\u00f3mo usar una celda como variable en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png","datePublished":"2023-11-17T09:32:12+00:00","dateModified":"2023-12-25T10:27:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/rango-variable\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/rango-variable\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/rango-variable\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-le-mot-cle-dim.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/rango-variable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo usar una celda como variable 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\/77","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=77"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/77\/revisions"}],"predecessor-version":[{"id":1240,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/77\/revisions\/1240"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}