{"id":210,"date":"2013-01-17T00:06:03","date_gmt":"2013-01-16T13:06:03","guid":{"rendered":"http:\/\/www.rtb.com.au\/blog\/?p=210"},"modified":"2023-11-14T12:47:07","modified_gmt":"2023-11-14T01:47:07","slug":"excel-vba-selection-and-navigation-techniques","status":"publish","type":"post","link":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/","title":{"rendered":"Excel VBA Selection and Navigation"},"content":{"rendered":"

\"MicrosoftPeople often ask me about selection and navigation techniques using keyboard shortcuts\u00a0when I’m teaching Macros in an Advanced Excel course.\u00a0However, when I’m teaching\u00a0students how to program for the first time in an Excel VBA course:<\/p>\n

Question: How do I select or navigate using Excel VBA?<\/em><\/p>\n

In this article I’m going to show you some basic techniques on how to go about it.<\/p>\n

Before I continue, I will refer to the active cell in 2 ways. In my blog I will use ‘active cell’<\/em> which is the correct way to say it in English during my explanations. The second way I will use it is ‘Activecell’<\/em>. This will be all one word starting with a capital. This is how it is written in Excel VBA.<\/p>\n

Firstly, you can record the process using the Excel Macro Recorder. Depending on the outcome you are trying to achieve you may want to record in the macro in absolute or relative mode. If your wondering about the difference between the two modes, the recorder will specifically hard code the cell references that you select during the recording process whereas relative mode will move\/select so many rows and columns based on the location of your active cell at the time you run the macro. This is why we call it a relative macro.<\/p>\n

To simplify, if you start in cell A1 and record an absolute macro to move to cell A3, the macro recorder would specifically record:<\/p>\n

Range(“A3”).Select<\/strong>
\ni.e. select cell A3<\/em>.<\/p>\n

That means that when you run a macro with this VBA code instruction it will always return to the same location (which in this case is cell A3) no matter where your active cell is located when you run the macro.<\/p>\n

Alternatively if you record a macro in relative mode it records the VBA code to move down 2 rows from your current position (aka the active cell):<\/p>\n

Activecell.Offset(2,0).Range(“A1”).Select<\/strong><\/p>\n

This basically says, starting from the active cell
\n Activecell<\/strong>
\nmove down 2 rows
\n Offset(2,0)<\/strong>
\nand select 1 cell
\n Range(“A1”).Select<\/strong><\/p>\n

NB** This is not cell A1. When combine with ‘Activecell.Offset’ Range(“A1”) is how many cells to select relative to the Activecell after you have moved (offset). For instance, if I wanted to move from cell A1 down 5 rows, across 3 columns and then select 3 rows down and 2 columns across then the VBA code would be:<\/p>\n

Activecell.Offset(5,3).Range(“A1:B3”).Select<\/strong><\/p>\n

\"Activecell<\/a>
Activecell.Offset(5,3).Range(“A1:B3”).Select<\/figcaption><\/figure>\n

Now that I’ve discussed the basic principles behind recording Absolute and Relative Macros I’d like to move on to some other examples of navigating and selecting data using Excel VBA. If your wondering if you can use the macro recorder to achieve this code than the answer is yes, although I tend to hand code these instructions.<\/p>\n

TIP!<\/strong>
\nLearn your navigational keyboard shortcuts. They come in very handy when recording macros. You can find some of these on our main website: Excel Keyboard Shortcuts<\/a><\/p>\n

Navigational VBA code:<\/h2>\n

The next line of VBA code will navigate DOWN to the first or last cell in a block of data. I recorded this using the standard Excel keyboard shortcut of Ctrl + ARROW DOWN<\/em><\/p>\n

Selection.End(xlDown).Select<\/strong><\/p>\n

If you were currently located at the top of a column of data it will move from the current location (active cell) down to the last cell of unbroken data in the same column. Run it again and it would move down to the first cell in the next block of data. Run it again and it moves to the last cell of the next block of data and so on. If there is no other data in the column it navigates to the very end of the column which is located on row 1,048,576 of the current column.<\/p>\n

This will work in any direction if you replace the xlDown with any of the following:
\nxlUp
\nxlToLeft
\nxlToRight<\/p>\n

Navigation and Selection VBA Code:<\/h2>\n

The following line of Excel VBA code will select a column of data as long as there is no blank cells in the column. Select the header or first cell at the top of the column first before running this line of code.<\/p>\n

Range(Selection, Selection.End(xlDown)).Select<\/strong><\/p>\n

\"Select<\/a>
Select to the end of a column<\/figcaption><\/figure>\n

Again, this will work in any direction if you replace the xlDown with any of the following:
\nxlUp
\nxlToLeft
\nxlToRight<\/p>\n

For more information on the Range Object in Excel VBA<\/a><\/p>\n

In summary, the above 2 lines of VBA code and their variations are a great way to start to learn how to navigate and select data . In my next post on this topic I’ll show you how to select data when the selections are more complex. Most of these will have to be hand coded. If your a beginner, practice these before moving on.<\/p>\n

Next Article: Excel VBA Selection and Navigation Techniques – Part 2<\/a><\/p>\n

Need to learn Excel VBA – Click here for course details<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

People often ask me about selection and navigation techniques using keyboard shortcuts\u00a0when I’m teaching Macros in an Advanced Excel course.\u00a0However, when I’m teaching\u00a0students how to program for the first time in an Excel VBA course: Question: How do I select or navigate using Excel VBA? In this article I’m going to show you some basic … Continue reading “Excel VBA Selection and Navigation”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-excel-vba-tips"],"yoast_head":"\r\nExcel VBA Selection and Navigation - Raising the Bar Blog<\/title>\r\n<meta name=\"description\" content=\"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Excel VBA Selection and Navigation - Raising the Bar Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Raising the Bar Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/raisingthebartraining\/\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/raisingthebartraining\" \/>\r\n<meta property=\"article:published_time\" content=\"2013-01-16T13:06:03+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-11-14T01:47:07+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif\" \/>\r\n<meta name=\"author\" content=\"Craig Holmes\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Craig Holmes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\"},\"author\":{\"name\":\"Craig Holmes\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b\"},\"headline\":\"Excel VBA Selection and Navigation\",\"datePublished\":\"2013-01-16T13:06:03+00:00\",\"dateModified\":\"2023-11-14T01:47:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\"},\"wordCount\":846,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif\",\"articleSection\":[\"Excel VBA Tips\"],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\",\"name\":\"Excel VBA Selection and Navigation - Raising the Bar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif\",\"datePublished\":\"2013-01-16T13:06:03+00:00\",\"dateModified\":\"2023-11-14T01:47:07+00:00\",\"description\":\"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage\",\"url\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif\",\"contentUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rtb.com.au\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel VBA Selection and Navigation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#website\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/\",\"name\":\"Raising the Bar Blog\",\"description\":\"Computer Training Courses\",\"publisher\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rtb.com.au\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\",\"name\":\"Raising the Bar\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png\",\"contentUrl\":\"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png\",\"width\":220,\"height\":113,\"caption\":\"Raising the Bar\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/raisingthebartraining\/\",\"https:\/\/x.com\/rtb_training\",\"https:\/\/www.instagram.com\/raisingthebartraining\/\",\"https:\/\/www.linkedin.com\/company\/1814856\/\",\"https:\/\/www.youtube.com\/channel\/UC0Qj5rg6wRga_2EN6hFEnCA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b\",\"name\":\"Craig Holmes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g\",\"caption\":\"Craig Holmes\"},\"description\":\"Microsoft Office Master Instructor and owner of Raising the Bar. Formerly trained as an Aircraft Technician with the RAAF\",\"sameAs\":[\"http:\/\/www.rtb.com.au\",\"https:\/\/www.facebook.com\/raisingthebartraining\"],\"url\":\"https:\/\/www.rtb.com.au\/blog\/author\/caholmes\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel VBA Selection and Navigation - Raising the Bar Blog","description":"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.","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:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/","og_locale":"en_US","og_type":"article","og_title":"Excel VBA Selection and Navigation - Raising the Bar Blog","og_description":"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.","og_url":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/","og_site_name":"Raising the Bar Blog","article_publisher":"https:\/\/www.facebook.com\/raisingthebartraining\/","article_author":"https:\/\/www.facebook.com\/raisingthebartraining","article_published_time":"2013-01-16T13:06:03+00:00","article_modified_time":"2023-11-14T01:47:07+00:00","og_image":[{"url":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif","type":"","width":"","height":""}],"author":"Craig Holmes","twitter_misc":{"Written by":"Craig Holmes","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#article","isPartOf":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/"},"author":{"name":"Craig Holmes","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b"},"headline":"Excel VBA Selection and Navigation","datePublished":"2013-01-16T13:06:03+00:00","dateModified":"2023-11-14T01:47:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/"},"wordCount":846,"commentCount":0,"publisher":{"@id":"https:\/\/www.rtb.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage"},"thumbnailUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif","articleSection":["Excel VBA Tips"],"inLanguage":"en-AU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/","url":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/","name":"Excel VBA Selection and Navigation - Raising the Bar Blog","isPartOf":{"@id":"https:\/\/www.rtb.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage"},"thumbnailUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif","datePublished":"2013-01-16T13:06:03+00:00","dateModified":"2023-11-14T01:47:07+00:00","description":"Learn selection and navigate techniques in your excel worksheets using Excel VBA. We start with the basics and move through to more complex selections.","breadcrumb":{"@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#primaryimage","url":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif","contentUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/microsoft-excel-navigation.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rtb.com.au\/blog\/excel-vba-selection-and-navigation-techniques\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rtb.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel VBA Selection and Navigation"}]},{"@type":"WebSite","@id":"https:\/\/www.rtb.com.au\/blog\/#website","url":"https:\/\/www.rtb.com.au\/blog\/","name":"Raising the Bar Blog","description":"Computer Training Courses","publisher":{"@id":"https:\/\/www.rtb.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rtb.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.rtb.com.au\/blog\/#organization","name":"Raising the Bar","url":"https:\/\/www.rtb.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png","contentUrl":"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png","width":220,"height":113,"caption":"Raising the Bar"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/raisingthebartraining\/","https:\/\/x.com\/rtb_training","https:\/\/www.instagram.com\/raisingthebartraining\/","https:\/\/www.linkedin.com\/company\/1814856\/","https:\/\/www.youtube.com\/channel\/UC0Qj5rg6wRga_2EN6hFEnCA"]},{"@type":"Person","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b","name":"Craig Holmes","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g","caption":"Craig Holmes"},"description":"Microsoft Office Master Instructor and owner of Raising the Bar. Formerly trained as an Aircraft Technician with the RAAF","sameAs":["http:\/\/www.rtb.com.au","https:\/\/www.facebook.com\/raisingthebartraining"],"url":"https:\/\/www.rtb.com.au\/blog\/author\/caholmes\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":58,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":724,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/210\/revisions\/724"}],"wp:attachment":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}