{"id":4183,"date":"2024-02-03T01:00:36","date_gmt":"2024-02-03T01:00:36","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4183"},"modified":"2024-02-03T01:00:36","modified_gmt":"2024-02-03T01:00:36","slug":"range-object-tutorial-in-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/","title":{"rendered":"Excel Macro Beginners – What is Range Object in Excel VBA"},"content":{"rendered":"

Dear readers,<\/p>\n

\nBefore we discuss the Range Object<\/strong> technically, let us see what is RANGE in excel?<\/i><\/strong> In a very simple manner if I define Range, I can say that RANGE<\/strong> is a collections of cells which are in a sequence.<\/i> This collection can have one or more than one cell.\n<\/p>\n

\nAs I have defined, Range is a collection of cells, but why in a sequence? Suppose I have a combination of cells A1, B2, D7 and E9<\/strong>. Will I call this combination as a Range? No, I can not call this collection as a Range because these cells are not in a sequence.
\nIf I have a collection of Cells A1, B1, C1 and D1<\/strong> then I can say that this is a Range from A1<\/strong> to D1<\/strong>. Sequence of cells can be Vertical<\/strong> or Horizontal<\/strong> or both at the same time which will represent a range in a tabular format.\n<\/p>\n

Now you know what is Range in Excel Workbook. To represent or access this cell range, the Object which is used in Excel VBA is called Range Object.<\/strong> Range Object is the most important and used Object in excel VBA. This article will give you an insight about some important and useful properties and methods of the Range Object.<\/p>\n

\nAs I said above, in this article you are going to learn some useful properties and methods of Range Object. Before you go there, you should know what is Property<\/i> and <\/i>Method<\/i> of an Object in Excel VBA?<\/p>\n

What is Property of an Object?<\/h1>\n

Property of an Object is something which has an Object. Basically it describes the Object.<\/p>\n

What is Method of an Object?<\/h1>\n

Method of an Object is something which is performed on that Object.
\nThis is the main difference between a property and method of an Object. Method is an action which is performed on an Object and Property is something which defines the object.\n<\/p>\n

Syntax<\/h2>\n

Typically following is the syntax of referring a Range in Excel VBA:
\n<\/p>\n

Range(“A1:G5”)<\/p>\n

<\/strong><\/p>\n

Above statement will represent all the cells from A1 to G5 as shown in below pic:
\n 
\n

\"Excel

Excel VBA - Rang Object<\/p><\/div>
\n <\/p>\n

\n

With above example you can see that Range(“A1:G5”)<\/strong> is representing the whole area from Cell A1 to G5. This range is UNIQUE<\/i> in only one WorkSheet because the same range can be found in other worksheet of the same WorkBook. Therefore it becomes necessary to instruct your VBA code to access Range(“A1:G5”)<\/strong> of WHICH SHEET?<\/i> By default it assumes the range from the “Active Sheet”<\/strong>. So, if you want your code to access correct range of correct sheet then you should follow either of the below statements:<\/p>\n

\r\nWorksheets("SheetName").Range("A1:G5").value\r\n'***************OR*****************\r\nWorksheets("SheetName").Activate\r\nActiveSheet.Range("A1:G5").value\r\n<\/code><\/pre>\n
Examples:<\/h1>\n
Let see in detail by referring to different examples.<\/p>\n
How to read values from a Range Object<\/h1>\n
As you know a Range can hold one or more than one cell. When a Range is holding a single cell like Range(“A1”)<\/strong> then it will have a single value which can be stored in a variable easily like below:<\/p>\n
\r\nVal = Range(\"A1\").Value\r\n<\/code><\/pre>\n
But if your Range has more than one cell then it is stored in an Array format and Range(“A1:G5”).Value<\/strong> will return a Two dimensional array holding all the cells values of that range. To know more about reading such range and dealing with the Array read this article.<\/strong><\/a><\/p>\n
How to write values in to a Range in Excel VBA<\/h1>\n
Let us see writing values in a Range using Range Object in VBA.<\/p>\n
i) Range with a Single Cell in Excel VBA<\/h2>\n
\r\nRange(\"A1\").Value = Val \r\n<\/code><\/pre>\n
Above statement will write the value of variable Val<\/i><\/strong> in Cell A1. This is simple and no issue with that.<\/p>\n
i) Range with a Multiple Cells in Excel VBA<\/h2>\n
\r\nRange(\"A1:D1\").Value = Val \r\n<\/code><\/pre>\n
Now in this case variable Val<\/i><\/strong> has a single value whereas Range(“A1:D1”) has 4 cells. In such case that single value will be written in all the cells of the Range Object.<\/p>\n
How to Select a Range through Excel VBA<\/h1>\n
\r\nRange(\"A1:D1\").Select\r\n<\/code><\/pre>\n
Selection of a range is a Method. This method performs a Selection<\/strong> operation of the given range. This does not return anything hence no variable required to capture the returned value.<\/p>\n
How to clear Contents of a Range<\/h1>\n
\r\nRange(\"A1:D1\").ClearContents\r\n<\/code><\/pre>\n
This is another important method of Range Object. It is used to clear all the contents of a Range.
\nNote: <\/strong>It clears the data or formula written in a cell but it does not clear the formatting done on a cell or Range. To clear formatting done on a Range, you can use .ClearFormats<\/i><\/strong>.<\/p>\n
Excel VBA to get total count of Rows in a Range<\/h1>\n
.Rows.Count<\/i> is the property which returns the total number of rows in the Range.<\/p>\n
\r\nMsgbox Range(\"A1:D4\").Rows.Count\r\n<\/code><\/pre>\n
Above statement will return Rows Count as 4 because above Range(“A1:D4”) has got 4 rows (From Row 1 to Row 4).<\/p>\n
How to get a total count of Columns in a Range<\/h1>\n
.Columns.Count<\/i> is the property which returns the total number of Columns in the Range.<\/p>\n
\r\nMsgbox Range(\"A1:D4\").Columns.Count\r\n<\/code><\/pre>\n
Above statement will return Column Count as 4 because above Range(“A1:D4”) has got 4 Columns (From Column A to Column D).<\/p>\n
Excel VBA to get count of cells in a Range<\/h2>\n
.Cells.Count<\/i> is the property which returns the total number of Cells in the Range.<\/p>\n
\r\nMsgbox Range(\"A1:D4\").Cells.Count\r\n<\/code><\/pre>\n
Above statement will return total cell Count as 16 because above Range(“A1:D4”) has got 4 columns and 4 Rows hence the total number of cells are 4×4=16.<\/p>\n
How to declare a Range Object in Excel VBA<\/h1>\n
You can define a Range object simply by following this syntax:<\/p>\n
Dim myRangeVariable<\/i> as Range<\/p>\n
You can easily assign a Range to this variable as shown in below code:<\/p>\n
\r\nSub range_declaration()\r\nDim myRangeObject As Range\r\nmyRangeObject = Range(\"A1:D4\")\r\nEnd Sub\r\n<\/code><\/pre>\n
Now you can use your Range variable myRangeObject<\/i><\/strong> same as Range(“A1:D4”). It means you can use all the methods and properties of a Range Object can be used directly on myRangeObject<\/i><\/strong> variable.<\/p>\n
\n
I have tried to cover many Properties and Methods of Range Object but there are lot more properties and methods available on Range Object. In VBA code windows as soon as you press DOT (.)<\/i><\/strong> sign after Range(“A1:D4”) whole list of Methods and Properties will be displayed. Though Names given to every property and methods are self-explanatory still if you have any question or doubt, you can take help in Excel Help file. It is very rich. If you still need my help, ask me by writing your comment here.\n<\/p><\/blockquote>\n<\/span>","protected":false},"excerpt":{"rendered":"
Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I can say that RANGE is a collections of cells which are in a sequence. This collection can have one or more than one cell. As I have defined, […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1674,1679],"tags":[],"yoast_head":"\nExcel Macro Beginners - What is Range Object in Excel VBA - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Beginners - What is Range Object in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-03T01:00:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/07\/Rang-Object-Demo-1.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Beginners – What is Range Object in Excel VBA\",\"datePublished\":\"2024-02-03T01:00:36+00:00\",\"dateModified\":\"2024-02-03T01:00:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\"},\"wordCount\":1079,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Macro\",\"Excel Macro Basics\",\"Excel Macro Beginner\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\",\"name\":\"Excel Macro Beginners - What is Range Object in Excel VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2024-02-03T01:00:36+00:00\",\"dateModified\":\"2024-02-03T01:00:36+00:00\",\"description\":\"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Beginners – What is Range Object in Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Macro Beginners - What is Range Object in Excel VBA - Let's excel in Excel","description":"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range","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:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Beginners - What is Range Object in Excel VBA","og_description":"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range","og_url":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2024-02-03T01:00:36+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/07\/Rang-Object-Demo-1.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Beginners – What is Range Object in Excel VBA","datePublished":"2024-02-03T01:00:36+00:00","dateModified":"2024-02-03T01:00:36+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/"},"wordCount":1079,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Macro","Excel Macro Basics","Excel Macro Beginner"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/","url":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/","name":"Excel Macro Beginners - What is Range Object in Excel VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2024-02-03T01:00:36+00:00","dateModified":"2024-02-03T01:00:36+00:00","description":"Detailed tutorial of Range Object in Excel Macro. Excel VBA to count cells, columns, rows in a range. Clear contents of a range through Excel VBA. VBA to clear format of range","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/range-object-tutorial-in-excel-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Beginners – What is Range Object in Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4183"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4183"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4183\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}