{"id":173866,"date":"2023-11-26T15:05:16","date_gmt":"2023-11-26T14:05:16","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=173866"},"modified":"2023-11-26T15:10:38","modified_gmt":"2023-11-26T14:10:38","slug":"excel-vba-how-to-automate-tasks-with-this-language","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language","title":{"rendered":"Excel VBA: How to automate tasks with this language"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"173866\" class=\"elementor elementor-173866\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-152cbdf e-flex e-con-boxed e-con\" data-id=\"152cbdf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bf1ddd5 elementor-widget elementor-widget-heading\" data-id=\"bf1ddd5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\"><b>VBA is an object-oriented programming language. VBA stands for Visual Basic For Applications. It is an integration of Visual Basic with Microsoft Office applications (MS Excel, MS PowerPoint, MS Access, MS Word and MS Outlook).<\/b><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54554b9 elementor-widget elementor-widget-text-editor\" data-id=\"54554b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>Running VBA (Visual Basic for Applications) in Microsoft Office<\/strong> applications allows you to automate repetitive tasks. <strong>VBA Excel<\/strong> methods and objects are centered <a href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\">around Excel objects to manipulate,<\/a> such as cells or ranges, as well as rows and columns of data.<\/p><p>An object has properties and methods. A property allows you to assign a value or characteristic to the object, while a method enables you to perform an action with the object. For example, if you imagine an object representing a cell in VBA <a href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\">Excel,<\/a> one of its properties could be used to change the font or color of the cell (a characteristic), and a method could be used to delete the cell (an action). To call a property or method of a VBA object, you separate the object from the property or method with a dot in the code: Object.Property = value.<\/p><p>As you may know, when you record an automatic macro with Excel, it records your actions for later playback with a simple button click. These actions are actually recorded in <strong>VBA Excel code<\/strong>. What we propose is to create simple macros to view and understand the code generated. Through this process, we will explore fundamental objects and learn essential properties and methods to get started in the best way possible.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f3b5b61 e-flex e-con-boxed e-con\" data-id=\"f3b5b61\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8c28658 elementor-widget elementor-widget-heading\" data-id=\"8c28658\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Activating the Developer tab :<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86da44a elementor-widget elementor-widget-text-editor\" data-id=\"86da44a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Let&#8217;s start by enabling the Developer tab:<\/p><p>1. Go to the &#8220;File&#8221; menu.<br \/>2. Select &#8220;Options.&#8221;<br \/>3. Choose &#8220;Customize Ribbon.&#8221;<br \/>4. You&#8217;ll find the &#8220;Developer&#8221; tab, which is likely unchecked. Check the box next to it.<br \/>5. Click &#8220;OK.&#8221;<\/p><p>Now, you should see the Developer tab in Excel, which allows you to access VBA and create macros.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b763c45 e-flex e-con-boxed e-con\" data-id=\"b763c45\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0c3ecd0 elementor-widget elementor-widget-heading\" data-id=\"0c3ecd0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I create an automatic macro?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-307b056 elementor-widget elementor-widget-text-editor\" data-id=\"307b056\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We are going to <strong>create our first macro.<\/strong> The goal is to see the generated code. With a cell selected, typically A1 by default:<\/p><p>1. Go to the Developer tab on the ribbon.<br \/>2. Click on the &#8220;Record Macro&#8221; button.<br \/>3. In the dialog box, name the macro, for example, &#8220;test_mef.&#8221;<br \/>4. Keep &#8220;This Workbook&#8221; selected from the list to save the macro in this workbook.<br \/>5. Click &#8220;OK&#8221; to start recording.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b56a051 elementor-widget elementor-widget-text-editor\" data-id=\"b56a051\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>From this point, we need to perform only the strictly necessary actions, as Excel is recording them.<\/p><p>1. Click on the &#8220;B&#8221; button in the Home tab to make the text bold.<br \/>2. Choose a red fill color using the Home tab.<br \/>3. Then, set the font color to white.<\/p><p>These actions will be recorded by Excel in the macro.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-962df62 elementor-widget elementor-widget-text-editor\" data-id=\"962df62\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We can now stop the recording.<\/p><p>Click on the &#8220;Stop Recording&#8221; button.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8059574 elementor-widget elementor-widget-text-editor\" data-id=\"8059574\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For now, the macro only exists as VBA code. We will create a button for it.<\/p><p>1. Click on the &#8220;File&#8221; menu and choose &#8220;Options&#8221; from the list.<br \/>2. In the dialog box, select the &#8220;Quick Access Toolbar&#8221; category.<br \/>3. In the center, choose the &#8220;Macros&#8221; category.<br \/>4. Then, select the &#8220;test_mef&#8221; macro from the list below and click &#8220;Add.&#8221;<br \/>5. Click on &#8220;Modify&#8221; at the bottom to choose an image for the button.<br \/>6. Click &#8220;OK&#8221; twice to confirm both dialog boxes.<\/p><p>Now, you should have a button on the Quick Access Toolbar that runs the &#8220;test_mef&#8221; macro.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9cf75f1 elementor-widget elementor-widget-text-editor\" data-id=\"9cf75f1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The button now appears in the Quick Access Toolbar above the ribbon.<\/p><p>1. Enter some text in a cell and press CTRL + Enter to keep it active.<br \/>2. Click on the new button in the Quick Access Toolbar.<\/p><p>This should execute the &#8220;test_mef&#8221; macro, which applies formatting to the selected cell.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2554917 elementor-widget elementor-widget-text-editor\" data-id=\"2554917\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As you can see, the formatting properties defined by the macro are applied instantly to the selected cell.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-709bc39 e-flex e-con-boxed e-con\" data-id=\"709bc39\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-62ecaf4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"62ecaf4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Get better in Excel<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7055163 e-flex e-con-boxed e-con\" data-id=\"7055163\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d279c9b elementor-widget elementor-widget-heading\" data-id=\"d279c9b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I create a macro using VBA code?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e877c6b elementor-widget elementor-widget-text-editor\" data-id=\"e877c6b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We will write the macro and give it a new name. At this stage, its behavior will be similar to the previous macro; we will only change certain values.<\/p><p>In the code editor, copy the entire macro (from Sub to End Sub).<br \/>Paste it below, on the module page.<br \/>Change its name after Sub to: mef_bleue.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64e13ab elementor-widget elementor-widget-text-editor\" data-id=\"64e13ab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We now have a new macro with a new name, but for now, it performs exactly the same actions as the previous one. We want this new code to make the cell blue with dark gray text initially. So, we just need to focus on the<strong> values of the RGB() function components.<\/strong><\/p><p>Secondly, we would like this macro to be able to apply a border to the selection. Light blue can be obtained with the components: 40, 180, 255. Similarly, dark gray can be obtained with the components: 76, 76, 76. (We have this information thanks to the Paint tool).<\/p><p>Modify the color components of the RGB() functions in the code of this new macro like this:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0d3eef elementor-widget elementor-widget-text-editor\" data-id=\"f0d3eef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The code editor allows us to test it:<\/p><p>First, <strong>select a cell containing text on the worksheet<\/strong>, and then go back to the code editor and click anywhere between the boundaries of the procedure of the second macro to place the insertion point there. This is how the software will know which code to execute when asked.<\/p><p>Finally, click the button represented by a green arrow in the code editor&#8217;s toolbar.<\/p><p>In appearance, nothing happens. In fact, it happens very quickly.<\/p><p>Display the worksheet,<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5d0ac79 elementor-widget elementor-widget-text-editor\" data-id=\"5d0ac79\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You <strong>notice that the preselected cell has been affected.<\/strong> We have just executed a macro. Now we want to define a thick border for the selection using code. To do this, we could go through the object explorer and the properties window in the code editor. Both of these are accessible through the View menu. However, it&#8217;s even simpler to create an automatic macro and retrieve the code.<\/p><p>Here&#8217;s what you need to do:<\/p><p>1. Select a cell in the Excel workbook&#8217;s sheet.<\/p><p>2. In the Developer tab, click the &#8220;Record Macro&#8221; button and name it &#8220;Bordure.&#8221; Then, click OK to start recording.<\/p><p>3. Using the Borders button in the Home tab, set an outer thick border, and then click the &#8220;Stop Recording&#8221; button in the Developer tab.<\/p><p>4. Return to the code editor.<\/p><p>Under the `mef_bleue()` macro, you&#8217;ll see a new procedure. This is the `bordure()` macro that we just created. Its code may seem complicated, but it&#8217;s actually a systematic repetition of the same properties set in the same way. Excel treats borders independently. First, it sets the left border: `Selection.Borders(xlEdgeLeft)`, then the top border: `Selection.Borders(xlEdgeTop)`, and so on. However, it&#8217;s sufficient not to specify any parameters for the `Borders` property of the Selection object for VBA Excel to understand that we&#8217;re referring to the outer border.<\/p><p>To achieve this, follow these steps:<\/p><p>1. Select and copy the first `With` block.<\/p><p>2. Paste it into the `mef_bleue()` macro right below the line `Selection.Interior.Color = RGB(40, 180, 255),`.<\/p><p>3. Delete the parameters within the parentheses of the `Borders` property as well as the parentheses themselves.<\/p><p>This modification will apply a thick outer border to the selected cell within the `mef_bleue()` macro.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-92898e7 elementor-widget elementor-widget-text-editor\" data-id=\"92898e7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>By making these changes, we specify the entire border of the selection rather than just one of its sides.<\/p><p>Here are the modifications you need to make:<\/p><p>1. Delete the line `.TintAndShade = 0`, as it&#8217;s unnecessary, as we&#8217;ve seen before.<\/p><p>2. Replace the line `.ColorIndex = 0` with `.Color = RGB(76, 76, 76)`.<\/p><p>These modifications will ensure that the selected cell has a thick outer border and a text color of dark gray within the `mef_bleue()` macro.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ee175a elementor-widget elementor-widget-spacer\" data-id=\"1ee175a\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-column .elementor-spacer-inner{height:var(--spacer-size)}.e-con{--container-widget-width:100%}.e-con-inner>.elementor-widget-spacer,.e-con>.elementor-widget-spacer{width:var(--container-widget-width,var(--spacer-size));--align-self:var(--container-widget-align-self,initial);--flex-shrink:0}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container,.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer,.e-con>.elementor-widget-spacer>.elementor-widget-container,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer{height:100%}.e-con-inner>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner,.e-con>.elementor-widget-spacer>.elementor-widget-container>.elementor-spacer>.elementor-spacer-inner{height:var(--container-widget-height,var(--spacer-size))}<\/style>\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3b9c2f elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f3b9c2f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-scientist-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4cdae5 elementor-widget elementor-widget-spacer\" data-id=\"c4cdae5\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6ec1b8 elementor-widget elementor-widget-text-editor\" data-id=\"f6ec1b8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>`.ColorIndex = 0` sets the border color to black. We prefer the `.Color` property, as before, which allows us to define a specific border color using the `RGB()` function. In this case, we are setting the border color to be the same as the text color.<\/p><p>Select a cell on the worksheet, return to the code editor, place the insertion point within the bounds of the `mef_bleue()` procedure, and click the play arrow to execute the code.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c77fd3e elementor-widget elementor-widget-text-editor\" data-id=\"c77fd3e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The cell now <strong>appears with the previous formatting attributes plus the border.<\/strong><\/p><p>Back on the worksheet, the button appears next to the previous one. If you select cells and click on it, you will execute the macro in the same way as the previous one. Now, let&#8217;s clean up the previous work.<\/p><ul><li>Return to the code editor.<\/li><li>Select all lines of code within the `bordure()` procedure, from `Sub` to `End Sub`.<\/li><li>Delete them by pressing the Delete key on your keyboard.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a92b5d3 elementor-widget elementor-widget-text-editor\" data-id=\"a92b5d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>With its code deleted, the &#8220;bordure&#8221; macro will no longer be available in the list of macros, especially for creating buttons.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2210ff5 e-flex e-con-boxed e-con\" data-id=\"2210ff5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0966725 elementor-widget elementor-widget-heading\" data-id=\"0966725\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Range and Cells objects: how to use them?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cce84f6 elementor-widget elementor-widget-text-editor\" data-id=\"cce84f6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>What&#8217;s better than an automatic macro to find out which object allows us to select and manipulate a specific cell? Because so far, the Selection object implied that we were acting on a preselected range. And if we want to act on specific cells, referenced by their coordinates, what do we do? This is what we will answer by asking a macro to record us while we select a specific cell.<\/p><ul><li>Activate the Developer tab from the Excel workbook sheet,<\/li><li>Click on the Record a Macro button,<\/li><li>Name it, for example, &#8220;cellules,&#8221; and click OK to start,<br \/>Select, for example, cell G10 with the mouse,<\/li><li>Click the Stop Recording button on the Developer tab,<\/li><li>Display the code editor by clicking the Visual Basic button on the Developer tab.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84e75a8 elementor-widget elementor-widget-text-editor\" data-id=\"84e75a8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you don&#8217;t see your new macro in the code editor, it means it was written in a new module.<\/p><p>Double-click on the Module2 section from the Project window on the left.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e0d724 elementor-widget elementor-widget-text-editor\" data-id=\"6e0d724\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>excessively simple code of the macro appears<\/strong>. You can see the use of the Range object with the cell references enclosed in quotes as they are identified in Excel. Range originally refers to a range of cells, but if only a single cell is indicated, it points to that individual cell.<\/p><p>Associated with the Range object is the Select method. Remember, a method performs an action and doesn&#8217;t return a value to a property. Here, the action is to select the specified cell or range.<\/p><p>The Range object has properties and methods that are simple to explore for customizing and configuring cells.<\/p><p>In the editor, under the first line of code, type Range(&#8216;G10&#8217;).<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-703e5d3 elementor-widget elementor-widget-text-editor\" data-id=\"703e5d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>When you type the dot (.)<strong> after the Range object,<\/strong> you&#8217;re calling a property or method of the object. That&#8217;s why a small dropdown list appears as you type. It provides you with all the methods of the object (preceded by a green icon) as well as all its properties (preceded by a gray icon). If you type the first letters of the property, for example, <strong>the list will position you on properties starting with those letters.<\/strong><\/p><p>Type or select the Font property and then type another dot (.),<\/p><p>This way, you&#8217;re accessing properties derived from the Font property.<\/p><p>Type or select the Size property for the font size,<br \/>Assign it the value 12 (=12).<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8f377c elementor-widget elementor-widget-text-editor\" data-id=\"f8f377c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As we mentioned, the Range object is initially used to designate a range of cells. To do this, much like in Excel functions, you simply specify the references separated by a colon (:) for a range of contiguous cells.<\/p><p>Finally, there is the Cells object, which allows you to designate a cell based on its row and column numbers. This object expects two parameters: the row number and the column number. So, for cell C10, you would pass the values 10 for the row and 3 for the column. Since this object deals with cells, it has the same properties and methods as the Selection and Range objects.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-22784a5 e-flex e-con-boxed e-con\" data-id=\"22784a5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f3b7cee elementor-widget elementor-widget-text-editor\" data-id=\"f3b7cee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We hope you enjoyed this article. Feel free to subscribe to our newsletter to stay updated on the latest tech, data, and <a href=\"https:\/\/datascientest.com\/en\/ai-and-creativity-exploring-the-myth-vs-reality\">AI news.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff04f70 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ff04f70\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Subscribe to our newsletter<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-efade73 e-flex e-con-boxed e-con\" data-id=\"efade73\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-345b4d8 elementor-widget elementor-widget-html\" data-id=\"345b4d8\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"How do I create a macro using VBA code?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"We've got a new macro with a new name, but for now it performs exactly the same actions as the previous one. We want this new code to initially turn the cell blue with dark gray text. All we need to do is focus on the component values of the RGB() function. Secondly, we'd like this macro to be able to apply a border to the selection. A light blue can be obtained with the components: 40,180,255. Similarly, a dark gray can be obtained with the components: 76,76,76. ( We have this information thanks to the Paint tool )\"\".\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Range and Cells objects: how to use them\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The excessively simple macro code appears. Note the use of the Range object, with the cell references as identified in Excel enclosed in quotation marks. Range originally refers to a range of cells, but if only one cell is specified, that cell alone is pointed to. Associated with the Range object is the Select method. Remember, a method performs an action and does not assign a value to a property. Here, the action is to select the designated cell or range. The Range object therefore has a number of easy-to-understand properties and methods for customizing and parameterizing cells.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>VBA is an object-oriented programming language. VBA stands for Visual Basic For Applications. It is an integration of Visual Basic with Microsoft Office applications (MS Excel, MS PowerPoint, MS Access, MS Word and MS Outlook). Running VBA (Visual Basic for Applications) in Microsoft Office applications allows you to automate repetitive tasks. VBA Excel methods and [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":173872,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel VBA: How to automate tasks with this language<\/title>\n<meta name=\"description\" content=\"Automating tasks in Excel using Excel VBA (Visual Basic for Applications) involves writing code to instruct Excel to perform\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel VBA: How to automate tasks with this language\" \/>\n<meta property=\"og:description\" content=\"VBA is an object-oriented programming language. VBA stands for Visual Basic For Applications. It is an integration of Visual Basic with Microsoft Office\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-26T14:05:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-26T14:10:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/11\/Excel-VBA.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1025\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Excel VBA: How to automate tasks with this language\",\"datePublished\":\"2023-11-26T14:05:16+00:00\",\"dateModified\":\"2023-11-26T14:10:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"},\"wordCount\":1945,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\",\"url\":\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\",\"name\":\"Excel VBA: How to automate tasks with this language\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-11-26T14:05:16+00:00\",\"dateModified\":\"2023-11-26T14:10:38+00:00\",\"description\":\"Automating tasks in Excel using Excel VBA (Visual Basic for Applications) involves writing code to instruct Excel to perform\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel VBA: How to automate tasks with this language","description":"Automating tasks in Excel using Excel VBA (Visual Basic for Applications) involves writing code to instruct Excel to perform","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:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language","og_locale":"en_GB","og_type":"article","og_title":"Excel VBA: How to automate tasks with this language","og_description":"VBA is an object-oriented programming language. VBA stands for Visual Basic For Applications. It is an integration of Visual Basic with Microsoft Office","og_url":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-11-26T14:05:16+00:00","article_modified_time":"2023-11-26T14:10:38+00:00","og_image":[{"width":1025,"height":562,"url":"https:\/\/datascientest.com\/en\/files\/2023\/11\/Excel-VBA.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Excel VBA: How to automate tasks with this language","datePublished":"2023-11-26T14:05:16+00:00","dateModified":"2023-11-26T14:10:38+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language"},"wordCount":1945,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language","url":"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language","name":"Excel VBA: How to automate tasks with this language","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-11-26T14:05:16+00:00","dateModified":"2023-11-26T14:10:38+00:00","description":"Automating tasks in Excel using Excel VBA (Visual Basic for Applications) involves writing code to instruct Excel to perform","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/173866"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=173866"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/173866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/173872"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=173866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=173866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=173866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}