{"id":896,"date":"2013-12-06T01:54:46","date_gmt":"2013-12-06T01:54:46","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=896"},"modified":"2020-04-23T10:45:58","modified_gmt":"2020-04-23T10:45:58","slug":"excel-vba-2010-lesson-2-data-types-constants-and-variables","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/","title":{"rendered":"Excel  2010 VBA  Lesson 2: Variables, Constants and Data Types."},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\">[Lesson 1]<\/a>&lt;&lt;<a title=\"excel vba 2010 tutorial\" 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-3-array\/\">[Lesson 3]<\/a><\/strong><\/h4>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2.1 The Definition of Variables in Excel 2010 VBA&nbsp;<\/strong><\/h4>\n\n\n\n<p>In general, variables are something that varies or prone to variations, just like the files in your cabinet or the mailboxes where their contents always change from time to time.&nbsp;In Excel 2010<strong>&nbsp;<\/strong>VBA programming environment, variables are areas allocated by the computer memory to hold data.<\/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<p>To safeguard the data created in Excel 2010 VBA, we suggest that&nbsp; you migrate your essential programming\/testing environment into the cloud by remotely loading\/accessing your programming tools such as emulators and IDE`s on your preferred device(PC\/android\/iOS) with high performance hosted citrix xendesktop from CloudDesktopOnline at an unbelievable&nbsp;<a href=\"https:\/\/www.clouddesktoponline.com\/citrix-xen-desktop\/\" target=\"_blank\" rel=\"noopener noreferrer\">xendesktop pricing<\/a>. If you prefer a server, Rent a&nbsp;<a href=\"http:\/\/www.apps4rent.com\/gpu-virtual-desktop.html\" target=\"_blank\" rel=\"noopener noreferrer\">gpu dedicated server<\/a>&nbsp;from Apps4Rent with 24*7*365 days assured tech-support &amp; migration assistance.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2.2 Rules in Naming Variables<\/h4>\n\n\n\n<p>Like the mailboxes, each variable must be given a name. The following are the rules when naming a variable :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>They must not exceed 40 characters<\/li><li>No space is allowed<\/li><li>They must contain only letters, numbers and underscore characters<\/li><li>They must not&nbsp;begin with a number, must always begin with a letter<\/li><li>Period is not permitted<\/li><\/ul>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><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><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><br>Examples of valid and invalid variable names are displayed in Table 2.1<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Table 2.1<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th><strong>Valid Name<\/strong><\/th><th><strong>Invalid Name<\/strong><\/th><\/tr><tr><td>My_Car<\/td><td>My.Car<\/td><\/tr><tr><td>Year1234<\/td><td>1234Year<\/td><\/tr><tr><td>Long_Name999<\/td><td>Father&amp;Son<\/td><\/tr><tr><td>A8Group<\/td><td>A Group<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2.3 Data Types<\/strong><\/h4>\n\n\n\n<p>Excel 2010 VBA&nbsp; data types can be grossly divided into two types, the numeric data types and non-numeric data types. They are classified below:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2.3.1 Numeric Data Types<\/strong><\/h4>\n\n\n\n<p>Numeric data types are types of data that consist of numbers, which can be computed mathematically with&nbsp;various standard operators such as addition, subtraction, multiplication, division and more. Examples of numeric data types are examination marks, height, weight, number of students in a class, share values, the price of goods, monthly bills, fees and others.<\/p>\n\n\n\n<p><b>Table 2.2: Numeric Data Types<\/b><\/p>\n\n\n\n<div style=\"overflow-x: auto;\">\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<th width=\"18%\"><span style=\"font-family: Verdana;\"><b>Type<\/b><\/span><\/th>\n<th><b><span style=\"font-family: Verdana;\">Storage&nbsp;<\/span><\/b><\/th>\n<th><b><span style=\"font-family: Verdana;\">Range of Values<\/span><\/b><\/th>\n<\/tr>\n<tr>\n<td><span style=\"font-family: arial;\">Byte<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">1 byte<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">0 to 255<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Integer<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">2 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">-32,768 to 32,767<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Long&nbsp;<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">4 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">-2,147,483,648 to 2,147,483,648<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Single<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">4 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">-3.402823E+38 to -1.401298E-45 for negative values<br>1.401298E-45 to 3.402823E+38 for positive values.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Double<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">8 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">-1.79769313486232e+308 to -4.94065645841247E-324 for negative values<br>4.94065645841247E-324 to 1.79769313486232e+308 for positive values.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Currency<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">8 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">-922,337,203,685,477.5808 to 922,337,203,685,477.5807<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-family: Verdana;\">Decimal<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">12 bytes<\/span><\/td>\n<td><span style=\"font-family: Verdana;\">+\/- 79,228,162,514,264,337,593,543,950,335 if no decimal is use<br>+\/- 7.9228162514264337593543950335 (28 decimal places).<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n\n\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><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><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>2.3.2 Non-Numeric Data Types<\/strong><\/h4>\n\n\n\n<p>Non-numeric data types are data that cannot be manipulated mathematically using standard arithmetic operators. The non-numeric data comprises text or string data types, the Date data types, the Boolean data types that store only two values (true or false), Object data type and Variant data type .They are summarized in Table 2.3<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Table 2.3: Nonnumeric Data Types<\/h4>\n\n\n\n<div style=\"overflow-x: auto;\">\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<th><b>Data Type<\/b><\/th>\n<th><b>Storage<\/b><\/th>\n<th><b>Range<\/b><\/th>\n<\/tr>\n<tr>\n<td>String(fixed length)<\/td>\n<td>Length of string<\/td>\n<td>1 to 65,400 characters<\/td>\n<\/tr>\n<tr>\n<td>String(variable length)<\/td>\n<td>Length + 10 bytes<\/td>\n<td>0 to 2 billion characters<\/td>\n<\/tr>\n<tr>\n<td>Date<\/td>\n<td>8 bytes<\/td>\n<td>January 1, 100 to December 31, 9999<\/td>\n<\/tr>\n<tr>\n<td>Boolean<\/td>\n<td>2 bytes<\/td>\n<td>True or False<\/td>\n<\/tr>\n<tr>\n<td>Object<\/td>\n<td>4 bytes<\/td>\n<td>Any embedded object<\/td>\n<\/tr>\n<tr>\n<td>Variant(numeric)<\/td>\n<td>16 bytes<\/td>\n<td>Any value as large as Double<\/td>\n<\/tr>\n<tr>\n<td>Variant(text)<\/td>\n<td>Length+22 bytes<\/td>\n<td>Same as variable-length string<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>2.3.3 Testing Data Types<\/strong><\/h4>\n<p>We can test out the type of data held by a variant by using the function <strong>VarType.<\/strong>&nbsp;To run the test, enter the Excel 2010 VBA code IDE and create a subroutine such as below:<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">Sub TestVarType()\n MyVariable1 = \"Francis\"\n MsgBox VarType(MyVariable1)\n MyVariable1 = 1234\n MsgBox VarType(MyVariable1)\nEnd Sub\n<\/pre>\n<p>When you run the macro, the message box will first display 8, which means it is a string. It will display 2 subsequently, which means it is an integer. We can call MyVariable1 a variant data type, and Excel&nbsp;2010 VBA is clever enough to automatically identify the type of data.<\/p>\n<h3><strong>2.4 Declaration of variables<\/strong><\/h3>\n<p>In Excel&nbsp; VBA 2010, we need to declare the variables before using them by assigning names and data types.<\/p>\n<h4><strong>2.4.1 Implicit Declaration<\/strong><\/h4>\n<p>We can use a variable without openly(explicitly) declare it if we assign an initial value to it. For example,<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">MyFirstName=\"John\"\n<\/pre>\n<p>Excel&nbsp; 2010 VBA&nbsp; will automatically create a variable MyFirstName as a variant, and it will hold the data as John. This type of declaration is called implicit declaration.<\/p>\n<h4><strong>2.4.2 Explicit Declaration<\/strong><\/h4>\n<p>Implicit declaration of the variable often leads to errors in writing code, therefore, it is better to declare a variable explicitly. It is &nbsp;declared using the&nbsp;<b>Dim<\/b>&nbsp;statement&nbsp;as follows:<\/p>\n<blockquote><p>Dim&nbsp;<i>VariableName<\/i>&nbsp;As&nbsp;<i>DataType<\/i><\/p><\/blockquote>\n<p>If you want to declare more variables, you can declare them in separate lines or you may also combine more in one line, separating each variable with a comma, as follows:<\/p>\n<blockquote><p>Dim&nbsp;<i>VariableName1<\/i>&nbsp;As&nbsp;<i>DataType<\/i>1,&nbsp;<i>VariableName2<\/i>&nbsp;As&nbsp;<i>DataType<\/i>2,&nbsp;<i>VariableName3<\/i>&nbsp;As&nbsp;<i>DataType<\/i>3<\/p><\/blockquote>\n<p><b>Example 2.1<\/b><\/p>\n<pre style=\"font-size: 110%;\">Dim password As String\nDim yourName As String\nDim firstnum As Integer\nDim secondnum As Integer\nDim total As Integer\nDim doDate As Date\nDim password As String,&nbsp; yourName As String, firstnum As Integer<\/pre>\n<p>For fixed-length string, you can use the statement to declare the variable:<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">Dim VariableName as String * n,\n<\/pre>\n<p>where n defines the number of characters the string can hold.<br>Example:<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">Dim yourName as String * 10\n<\/pre>\n<p>yourName can hold no more than 10 Characters.<\/p>\n<p><strong>2.4.3 &nbsp;Scope of Declaration<\/strong><\/p>\n<p>Other than using the Dim keyword to declare the data, you can also use other keywords to declare the data. These keywords indicate the scope of the declaration, they are <strong>private ,static<\/strong> and <strong>public<\/strong>,as follows:<\/p>\n<p>Private VariableName as Datatype<br>Static VariableName as Datatype<br>Public VariableName as Datatype<\/p>\n<p>The Private declares a local variable or a variable that is local to a procedure or module in Excel VBA 2010.<\/p>\n<p>The Static keyword declares a variable that can be used multiple times, even after a procedure has been terminated. Most variables created inside a procedure are discarded by Visual Basic when the procedure is finished, static keyword preserves the value of a variable even after the procedure is terminated.<\/p>\n<p>The Public keyword declares a global variable, which means it can be used by all the procedures and modules of the whole program.<\/p>\n<h3><strong>2.5 &nbsp;Constants<\/strong><\/h3>\n<p>Constants are different from variables in the sense that their values do not change during the running of the program. In Excel 2010 VBA , the statement to declare a constant is<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">Const Constant Name As Data Type = Value\n<\/pre>\n<p>Examples:<\/p>\n<pre style=\"font-size: 110%; width: 80%;\">Const Pi As Single=3.142\nConst Temp As Double=37\nConst Score As Single=100\n<\/pre>\n<p><script async=\"\" src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br><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><script><br \/>\n     (adsbygoogle = window.adsbygoogle || []).push({});<br \/>\n<\/script><\/p>\n<h4 style=\"text-align: center;\"><strong><a href=\"http:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor\/\">[Lesson 1]<\/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-3-array\/\">[Lesson 3]<\/a><\/strong><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>[Lesson 1]&lt;&lt;[Table of Contents]&gt;&gt;[Lesson 3] 2.1 The Definition of Variables in Excel 2010 VBA&nbsp; In general, variables are something that varies or prone to variations, just like the files in your cabinet or the mailboxes where their contents always change from time to time.&nbsp;In Excel 2010&nbsp;VBA programming environment, variables are areas allocated by the computer &hellip; <a href=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel  2010 VBA  Lesson 2: Variables, Constants and Data Types.&#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":[8,9],"tags":[],"class_list":["post-896","page","type-page","status-publish","hentry","category-data-types","category-variables"],"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 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor<\/title>\n<meta name=\"description\" content=\"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel 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-2-data-types-constants-and-variables\/\" \/>\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 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\" \/>\n<meta property=\"og:description\" content=\"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel Excel 2010 VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\" \/>\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=\"2020-04-23T10:45:58+00:00\" \/>\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-2-data-types-constants-and-variables\/\",\"url\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\",\"name\":\"Excel 2010 VBA Lesson 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor\",\"isPartOf\":{\"@id\":\"https:\/\/excelvbatutor.com\/#website\"},\"datePublished\":\"2013-12-06T01:54:46+00:00\",\"dateModified\":\"2020-04-23T10:45:58+00:00\",\"description\":\"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel Excel 2010 VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/excelvbatutor.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2010 VBA Lesson 2: Variables, Constants and Data Types.\"}]},{\"@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 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","description":"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel 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-2-data-types-constants-and-variables\/","og_locale":"en_US","og_type":"article","og_title":"Excel 2010 VBA Lesson 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","og_description":"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel Excel 2010 VBA","og_url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/","og_site_name":"Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","article_modified_time":"2020-04-23T10:45:58+00:00","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-2-data-types-constants-and-variables\/","url":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/","name":"Excel 2010 VBA Lesson 2: Variables, Constants and Data Types. - Learn Excel VBA Online \u2013 Step-by-Step Tutorials &amp; Courses | ExcelVBATutor","isPartOf":{"@id":"https:\/\/excelvbatutor.com\/#website"},"datePublished":"2013-12-06T01:54:46+00:00","dateModified":"2020-04-23T10:45:58+00:00","description":"This Excel VBA 2010 lesson explains Variables, constants and data types in Excel Excel 2010 VBA","breadcrumb":{"@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-2010-lesson-2-data-types-constants-and-variables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/excelvbatutor.com\/"},{"@type":"ListItem","position":2,"name":"Excel 2010 VBA Lesson 2: Variables, Constants and Data Types."}]},{"@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\/896","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=896"}],"version-history":[{"count":138,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/896\/revisions"}],"predecessor-version":[{"id":3455,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/pages\/896\/revisions\/3455"}],"wp:attachment":[{"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/media?parent=896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/categories?post=896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelvbatutor.com\/index.php\/wp-json\/wp\/v2\/tags?post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}