{"id":5753,"date":"2017-03-11T00:10:15","date_gmt":"2017-03-11T00:10:15","guid":{"rendered":"https:\/\/wordherd.io\/how-to-use-the-vba-current-region-method-in-excel\/"},"modified":"2017-03-11T00:10:15","modified_gmt":"2017-03-11T00:10:15","slug":"how-to-use-the-vba-current-region-method-in-excel","status":"publish","type":"post","link":"https:\/\/wordherd.io\/es\/blog\/how-to-use-the-vba-current-region-method-in-excel\/","title":{"rendered":"How To Use The VBA Current Region Method In Excel"},"content":{"rendered":"<p>Accessing the Present Area is without doubt one of the most beneficial VBA methods in Excel. Not solely can it choose a knowledge set or desk, it allows you to entry particular person cells, rows and columns inside the area; making it very helpful for brand new Excel builders:<\/p>\n<ul>\n<li>Search a whole desk<\/li>\n<li>Choose a number of columns to make use of in a chart<\/li>\n<li>Outline rows and cells for highlighting<\/li>\n<\/ul>\n<p><strong>An Instance Of Choosing The Present Area<\/strong><\/p>\n<p>The traditional syntax for choosing the <em>currentRegion <\/em>is as follows:<\/p>\n<p><pre>\n<br>Vary(cellAddress).currentRegion.choose\n<br><\/pre>\n<\/p>\n<p>Whereas it is smart to make use of the primary cell of the desk as the bottom for the area, any cell reference inside the area can be utilized. Let&#8217;s take a look at an instance of how you should use the present area in actual life.<\/p>\n<p>For instance we have to search a whole desk beginning at &#8220;A1&#8221; for an outlined textual content string:<\/p>\n<p><pre>\n<br>myText=\"textual content to seek for\"\n<br>myRange=\"a1\"\n<br>vary(myRange).currentRegion.choose<\/p><p>for every c in choice\n<br>if instr(c,myText) then\n<br>' match discovered\n<br>Finish if\n<br>subsequent\n<br><\/pre>\n<\/p>\n<p><strong>Accessing Cells, Rows And Columns Inside The Present Area<\/strong><\/p>\n<p>As a result of a area covers a number of rows and columns there are a number of completely different methods to entry objects inside the area:<\/p>\n<p>In a 2 row by four column desk (2 x four) you would possibly wish to know the deal with of the final cell within the desk, so you&#8217;ll be able to add information to the following row. This code identifies the following cell deal with for information enter by discovering the ultimate row and transferring to the following cell.<\/p>\n<p><pre>\n<br>Vary(myRange).currentRegion.choose\n<br>lastRow=choice.rows.depend\n<br>cellAddress=choice.rows(lastRow).cells(1).deal with\n<br>vary(cellAddress).offset(1,zero).activate\n<br><\/pre>\n<\/p>\n<p>Equally, if we needed to format every row, we might have to know what number of columns had been included within the area:<\/p>\n<p><pre>\n<br>cols=choice.columns.depend\n<br><\/pre>\n<\/p>\n<p>And should you had three columns and needed to return the 2nd column to incorporate as a collection vary in a chart you might use this line of code:<\/p>\n<p><pre>\n<br>myRange=choice.columns(2).deal with\n<br><\/pre>\n<\/p>\n<p>In a three x four desk, this could return a price within the kind <em>$B$1:$B$four<\/em> which coincidentally is the format to incorporate the column in a chart.<\/p>\n<p>It may be helpful to consider the Present Area as a group, and the cells, rows and columns are objects within the assortment having their very own properties. On this manner when you could entry the objects inside the area you are able to do so intuitively, slightly than counting on information of particular properties and strategies.<\/p>\n<p><strong>Abstract<\/strong><\/p>\n<p>The Present Area is one essentially the most helpful instruments for each new and skilled VBA builders.  understanding of its strategies and properties is important for efficient and productive Excel purposes.<\/p>\n<div class=\"source\"><a href=\"http:\/\/ezinearticles.com\/?How-To-Use-The-VBA-Current-Region-Method-In-Excel&#038;id=7296677\">Fuente<\/a> por <a href=\"http:\/\/ezinearticles.com\/expert\/Andy_L_Gibson\/1382722\">Andy L Gibson<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Accessing the Present Area is without doubt one of the most beneficial VBA methods in Excel. Not solely can it choose a knowledge set or desk, it allows you to entry particular person cells, rows and columns inside the area; making it very helpful for brand new Excel builders: Search a whole desk Choose a [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"categories":[15],"tags":[200,595],"builders":[],"industry":[],"platform":[],"class_list":["post-5753","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-wordpress","tag-wordpress-tutorial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration<\/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:\/\/wordherd.io\/es\/blog\/how-to-use-the-vba-current-region-method-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration\" \/>\n<meta property=\"og:description\" content=\"Accessing the Present Area is without doubt one of the most beneficial VBA methods in Excel. Not solely can it choose a knowledge set or desk, it allows you to entry particular person cells, rows and columns inside the area; making it very helpful for brand new Excel builders: Search a whole desk Choose a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordherd.io\/es\/blog\/how-to-use-the-vba-current-region-method-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"WordHerd WordPress Migration\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/wordherdio\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-11T00:10:15+00:00\" \/>\n<meta name=\"author\" content=\"WordHerd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@wordherdio\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"WordHerd\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/\"},\"author\":{\"name\":\"WordHerd\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\"},\"headline\":\"How To Use The VBA Current Region Method In Excel\",\"datePublished\":\"2017-03-11T00:10:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/\"},\"wordCount\":434,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"keywords\":[\"WordPress\",\"wordpress tutorial\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/\",\"name\":\"How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\"},\"datePublished\":\"2017-03-11T00:10:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/blog\\\/how-to-use-the-vba-current-region-method-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wordherd.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Use The VBA Current Region Method In Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#website\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"name\":\"WordHerd WordPress Migration\",\"description\":\"Website Migration Services\",\"publisher\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wordherd.io\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#organization\",\"name\":\"WordHerd WordPress Migration\",\"url\":\"https:\\\/\\\/wordherd.io\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"contentUrl\":\"https:\\\/\\\/wordherd.io\\\/wp-content\\\/uploads\\\/wordherd-trademark.png\",\"width\":1000,\"height\":315,\"caption\":\"WordHerd WordPress Migration\"},\"image\":{\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wordherd.io\\\/#\\\/schema\\\/person\\\/373419b97c0fbc45a3a16462bdba0fac\",\"name\":\"WordHerd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g\",\"caption\":\"WordHerd\"},\"sameAs\":[\"https:\\\/\\\/wordherd.io\",\"https:\\\/\\\/www.facebook.com\\\/wordherdio\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wordherd\",\"https:\\\/\\\/x.com\\\/wordherdio\"],\"url\":\"https:\\\/\\\/wordherd.io\\\/es\\\/blog\\\/author\\\/wordherd\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration","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:\/\/wordherd.io\/es\/blog\/how-to-use-the-vba-current-region-method-in-excel\/","og_locale":"es_ES","og_type":"article","og_title":"How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration","og_description":"Accessing the Present Area is without doubt one of the most beneficial VBA methods in Excel. Not solely can it choose a knowledge set or desk, it allows you to entry particular person cells, rows and columns inside the area; making it very helpful for brand new Excel builders: Search a whole desk Choose a [&hellip;]","og_url":"https:\/\/wordherd.io\/es\/blog\/how-to-use-the-vba-current-region-method-in-excel\/","og_site_name":"WordHerd WordPress Migration","article_author":"https:\/\/www.facebook.com\/wordherdio\/","article_published_time":"2017-03-11T00:10:15+00:00","author":"WordHerd","twitter_card":"summary_large_image","twitter_creator":"@wordherdio","twitter_misc":{"Escrito por":"WordHerd","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/#article","isPartOf":{"@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/"},"author":{"name":"WordHerd","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac"},"headline":"How To Use The VBA Current Region Method In Excel","datePublished":"2017-03-11T00:10:15+00:00","mainEntityOfPage":{"@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/"},"wordCount":434,"commentCount":0,"publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"keywords":["WordPress","wordpress tutorial"],"articleSection":["WordPress"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/","url":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/","name":"How To Use The VBA Current Region Method In Excel - WordHerd WordPress Migration","isPartOf":{"@id":"https:\/\/wordherd.io\/#website"},"datePublished":"2017-03-11T00:10:15+00:00","breadcrumb":{"@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/wordherd.io\/blog\/how-to-use-the-vba-current-region-method-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wordherd.io\/"},{"@type":"ListItem","position":2,"name":"How To Use The VBA Current Region Method In Excel"}]},{"@type":"WebSite","@id":"https:\/\/wordherd.io\/#website","url":"https:\/\/wordherd.io\/","name":"Migraci\u00f3n de WordHerd a WordPress","description":"Servicios de migraci\u00f3n de sitios web","publisher":{"@id":"https:\/\/wordherd.io\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordherd.io\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/wordherd.io\/#organization","name":"Migraci\u00f3n de WordHerd a WordPress","url":"https:\/\/wordherd.io\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/","url":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","contentUrl":"https:\/\/wordherd.io\/wp-content\/uploads\/wordherd-trademark.png","width":1000,"height":315,"caption":"WordHerd WordPress Migration"},"image":{"@id":"https:\/\/wordherd.io\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/wordherd.io\/#\/schema\/person\/373419b97c0fbc45a3a16462bdba0fac","name":"WordHerd","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bf8c7166601a64c6c57b67ffbeab8f8c6a378cca786da9a326c1a34a2ec6f860?s=96&d=mm&r=g","caption":"WordHerd"},"sameAs":["https:\/\/wordherd.io","https:\/\/www.facebook.com\/wordherdio\/","https:\/\/www.linkedin.com\/company\/wordherd","https:\/\/x.com\/wordherdio"],"url":"https:\/\/wordherd.io\/es\/blog\/author\/wordherd\/"}]}},"_links":{"self":[{"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/posts\/5753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/comments?post=5753"}],"version-history":[{"count":0,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/posts\/5753\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/media?parent=5753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/categories?post=5753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/tags?post=5753"},{"taxonomy":"builders","embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/builders?post=5753"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/industry?post=5753"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/wordherd.io\/es\/wp-json\/wp\/v2\/platform?post=5753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}