{"id":1367,"date":"2013-12-12T14:55:28","date_gmt":"2013-12-12T14:55:28","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=1367"},"modified":"2019-04-19T07:48:24","modified_gmt":"2019-04-19T07:48:24","slug":"excel-vba-2010-lesson-18-the-range-object","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/","title":{"rendered":"Excel 2010 VBA Lesson 18: The Range Object"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">&nbsp;<strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-17-introduction-to-excel-vba-objects-part-2\/\">[Lesson 17]<\/a>&lt;&lt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-19-the-worksheet-object\/\">[Lesson 19]<\/a><\/strong><\/h4>\n\n\n\n<p>The range is one of the most important and most commonly used Excel 2010 &nbsp;VBA &nbsp;objects. In fact, we have dealt with the Range object in previous lessons.<\/p>\n\n\n\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h4 class=\"wp-block-heading\">18.1 The Select Method<\/h4>\n\n\n\n<p>The Range object contains two arguments that specify a selected area on the spreadsheet. The syntax is\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Range(starting_cell,Ending_ Cell)<\/pre>\n\n\n\n<p>For example, to select the range from cell A1 to C6, the syntax is\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>Range(\u201cA1:C6\u2033).Select<\/strong>\n<\/pre>\n\n\n\n<p>where select is a method of the Range object.<\/p>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.1<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\n Range(\u201cA1:C6\u2033).Select\nEnd Sub\n<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>18.2 The Columns Property<\/strong><\/h4>\n\n\n\n<p>The columns property of the Range object is to select certain columns in the particular range specified by the Range object.<\/p>\n\n\n\n<p>The syntax is\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>Range(starting_cell,Ending_ Cell).Columns(i).Select<\/strong>\n<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Example 18.2<\/h4>\n\n\n\n<p>This example select column C in the range A1 to C6\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton2_Click()\n Range(\u201cA1:C6\u2033).Columns(3).Select\nEnd Sub\n<\/pre>\n\n\n\n<p>You can also use Cells(1,1) to Cells(6,3) instead of A1:C6, the syntax is\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Range(Cells(1,1),Cells(6,3)).Columns(3).Select\n<\/pre>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><br>\nThe output is as shown in Figure 18.1<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"357\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\" alt=\"excelvba2010_figure18.1\" class=\"wp-image-1370\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Figure 18.1<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>18.3 Using With Range\u2026\u2026End With<\/strong><\/h4>\n\n\n\n<p>You can also format font the cells in a particular column in terms of type, color, bold, italic, underlined and size using the With Range\u2026..End With Structure. It can also be used to format other Range properties like the background color. Using With Range\u2026.End With structure can save time and make the code cleaner.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.3<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\nWith Range(\u201cA1:C6\u2033).Columns(2)\n.Font.ColorIndex = 3\n.Font.Bold = True\n.Font.Italic = True\n.Font.Underline = True\n.Font.Name = \u201cTimes New Roman\u201d\n.Font.Size = 14\n.Interior.Color = RGB(255, 255, 0)\nEnd With\nEnd Sub\n<\/pre>\n\n\n\n<p>* Without using With Range\u2026.End With, you need to write every line in full, like this\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Range(\u201cA1:C6\u2033).Columns(2).Font.ColorIndex = 3\n<\/pre>\n\n\n\n<p>The output:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.2.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"312\" height=\"402\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.2.jpg\" alt=\"vba2010_figure18.2\" class=\"wp-image-1372\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Figure 18.2<\/strong><br>\n<script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>18.4 The Rows Property<\/strong><\/h4>\n\n\n\n<p>Basically, the syntax for the Rows property is similar to that of the Columns property, you just need to replace Columns with rows.<\/p>\n\n\n\n<p>The syntax of selecting a row within a certain range is\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>Range(starting_cell,Ending_ Cell).Rows(i).Select<\/strong>\n<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.4<\/strong><\/h4>\n\n\n\n<p>This following code selects the third row within the range A1 to F3\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton2_Click()\n Range(\u201cA1:F3\u2033).Rows(3).Select\nEnd Sub\n<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.3.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"375\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.3.jpg\" alt=\"vba2010_figure18.3\" class=\"wp-image-1377\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Figure 18.3<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.5: Using With Range\u2026End With for Rows<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\nWith Range(\u201cA1:F3\u2033).Rows(2)\n.Font.ColorIndex = 3\n.Font.Bold = True\n.Font.Italic = True\n.Font.Underline = True\n.Font.Name = \u201cTimes New Roman\u201d\n.Font.Size = 14\n.Interior.Color = RGB(255, 255, 0)\nEnd With\nEnd Sub\n<\/pre>\n\n\n\n<p>The Output<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.4.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"429\" height=\"354\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.4.jpg\" alt=\"vba2010_figure18.4\" class=\"wp-image-1379\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp; Figure 18.4<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>18.5 Using the Set keyword to Declare Range<\/strong><\/h4>\n\n\n\n<p>We can write Excel 2010 VBA code that can specify a certain range of cells using the&nbsp;<strong>Set<\/strong>&nbsp;keyword and then perform certain tasks according to a set of conditions.<\/p>\n\n\n\n<p>In Example 18.6, we shall write the ExcelVBA code such that it can accept range input from the user and then change the mark to blue if it is more than or equal to 50 and change it to red if the mark is less than 50.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.6<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\nDim rng, cell As Range, selectedRng As String\n selectedRng = InputBox(\u201cEnter your range\u201d)\n Set rng = Range(selectedRng)\nFor Each cell In rng\n If cell.Value &gt;= 50 Then\n  cell.Font.ColorIndex = 5\n Else\n  cell.Font.ColorIndex = 3\n End If\nNext cell\nEnd Sub\n<\/pre>\n\n\n\n<p><strong>Explanation:<\/strong><\/p>\n\n\n\n<p><em>The InputBox function is used to accept value from the users.<\/em><\/p>\n\n\n\n<p>rng and cell are declared as a Range variable using the Dim statement while selectedRng is declared as a string that receives input from the user.<\/p>\n\n\n\n<p>Once the input is obtained from the user, it is stored using the Set method and the Range function.<\/p>\n\n\n\n<p>For Each cell In rng \u2026\u2026Net cell is a loop that can iterate through the selected range, one cell at a time.<\/p>\n\n\n\n<p>The If\u2026Then\u2026Else statements are to specify the color of the font according to the range of values determined by the conditions.<\/p>\n\n\n\n<p>The Output<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.5.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"657\" height=\"450\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.5.jpg\" alt=\"vba2010_figure18.5\" class=\"wp-image-1382\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp;Figure 18.5<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>18.6 The Formula property<\/strong><\/h4>\n\n\n\n<p>You can use the Formula property of the Range object to write your own customized formula.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.7<\/strong><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\n Range(\u201cA1:B3\u2033).Columns(3).Formula = \u201c=A1+B1\u2033\nEnd Sub\n<\/pre>\n\n\n\n<p>In this example, the formula A1+B1 will be copied down column 3 (column C) from cell C1 to cell C3. The program automatically sums up the corresponding values down column A and column B and displays the results in column C, as shown in Figure 18.6<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.6.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"315\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure18.6.jpg\" alt=\"vba2010_figure18.6\" class=\"wp-image-1384\"\/><\/a><\/figure><\/div>\n\n\n\n<p><strong>&nbsp; Figure 18.6&nbsp;<\/strong><\/p>\n\n\n\n<p>The above example can also be rewritten and produces the same result as below:\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Range(\u201cA1:B3\u2033).Columns(3).Formula = \u201c=Sum(A1:B1)\u201d\n<\/pre>\n\n\n\n<p>There are many formulas in Excel VBA which we can use to simplify and speed up complex calculations. The formulas are categorized into Financial, Mathematical, Statistical, Date , Time and others. For example, in the statistical category, we have Average (Mean), Mode and Median<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.8<\/strong><\/h4>\n\n\n\n<p>In this example, the program computes the average of the corresponding values in column A and column B and displays the results in column C. For example, the mean of values in cell A1 and Cell B1 is computed and displayed in Cell C1. Subsequent means are automatically copied down Column C until cell C3.\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\n Range(\u201cA1:B3\u2033).Columns(3).Formula = \u201c=Average(A1:B1)\u201d\nEnd Sub\n<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 18.9: Mode<\/strong><\/h4>\n\n\n\n<p>In this example, the program computes the mode for every row in the range A1:E4 and displays them in column F. It also makes the font bold and red in color, as shown in Figure 15.6.\n<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Private Sub CommandButton1_Click()\n Range(\u201cA1:E4\u2033).Columns(6).Formula = \u201c=Mode(A1:E1)\u201d\n Range(\u201cA1:E4\u2033).Columns(6).Font.Bold = True\n Range(\u201cA1:E4\u2033).Columns(6).Font.ColorIndex = 3\nEnd Sub\n<\/pre>\n\n\n\n<p>The Output<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure-18.7.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"441\" height=\"306\" src=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/vba2010_figure-18.7.jpg\" alt=\"vba2010_figure 18.7\" class=\"wp-image-1386\"\/><\/a><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">Figure 18.7<\/h4>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3033628290023372\" data-ad-slot=\"9639157585\"><\/ins><br>\n<script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><br>\n<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">&nbsp;<strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-17-introduction-to-excel-vba-objects-part-2\/\">[Lesson 17]<\/a>&lt;&lt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial\/\">[Table of Contents]<\/a>&gt;&gt;<a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-19-the-worksheet-object\/\">[Lesson 19]<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;[Lesson 17]&lt;&lt;[Table of Contents]&gt;&gt;[Lesson 19] The range is one of the most important and most commonly used Excel 2010 &nbsp;VBA &nbsp;objects. In fact, we have dealt with the Range object in previous lessons. 18.1 The Select Method The Range object contains two arguments that specify a selected area on the spreadsheet. The syntax is Range(starting_cell,Ending_ &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel 2010 VBA Lesson 18: The Range Object&#8221;<\/span><\/a><\/p>\n","protected":false},"author":5012,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1367","page","type-page","status-publish","hentry","category-object"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor<\/title>\n<meta name=\"description\" content=\"This lesson explain the usage of the range object in excel 2010 VBA\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"og:description\" content=\"This lesson explain the usage of the range object in excel 2010 VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-19T07:48:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"315\" \/>\n\t<meta property=\"og:image:height\" content=\"357\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\",\"name\":\"Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\",\"datePublished\":\"2013-12-12T14:55:28+00:00\",\"dateModified\":\"2019-04-19T07:48:24+00:00\",\"description\":\"This lesson explain the usage of the range object in excel 2010 VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage\",\"url\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\",\"contentUrl\":\"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg\",\"width\":315,\"height\":357},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2010 VBA Lesson 18: The Range Object\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelvbatutor.com\/#website\",\"url\":\"https:\/\/excelvbatutor.com\/\",\"name\":\"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"description\":\"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.\",\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"This lesson explain the usage of the range object in excel 2010 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:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","og_description":"This lesson explain the usage of the range object in excel 2010 VBA","og_url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_modified_time":"2019-04-19T07:48:24+00:00","og_image":[{"width":315,"height":357,"url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/","url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/","name":"Excel 2010 VBA Lesson 18: The Range Object - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage"},"image":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage"},"thumbnailUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg","datePublished":"2013-12-12T14:55:28+00:00","dateModified":"2019-04-19T07:48:24+00:00","description":"This lesson explain the usage of the range object in excel 2010 VBA","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#primaryimage","url":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg","contentUrl":"https:\/\/excelvbatutor.com\/wp-content\/uploads\/2013\/12\/excelvba2010_figure18.1.jpg","width":315,"height":357},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-18-the-range-object\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Excel 2010 VBA Lesson 18: The Range Object"}]},{"@type":"WebSite","@id":"https:\/\/excelvbatutor.com\/#website","url":"https:\/\/excelvbatutor.com\/","name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel.","inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/1367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/users\/5012"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/comments?post=1367"}],"version-history":[{"count":44,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/1367\/revisions"}],"predecessor-version":[{"id":3327,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/1367\/revisions\/3327"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=1367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=1367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=1367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}