{"id":12142,"date":"2012-06-10T10:05:04","date_gmt":"2012-06-10T10:05:04","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1821"},"modified":"2022-08-12T11:17:46","modified_gmt":"2022-08-12T11:17:46","slug":"excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","title":{"rendered":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)"},"content":{"rendered":"

Let’s take a brief recap of all things you have studied so far in Excel Macro Tutorial.<\/p>\n

So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials<\/a>. You have learned about all the Controls available in Excel Macros and also how to use them. You have also learned How to Record and Run a Macro in Excel. You also have learnt some basic Programming Lessons as well like If Else Statements<\/a>, For Loop<\/a>, While and DO While Loops<\/a> etc.<\/p>\n

So far we have studied all the basic stuff about Excel Macro, which will be required for you to start developing a tool in Excel Macro.
\nHere I have collected a Set of questions or doubts, which are asked as soon as you start coding your own.<\/p>\n

\n
\n1. How to read or Write some value in an Excel Cell?
\n2. How to read or write something in an Excel Cell of a Specified Sheet of the same Workbook.
\n3. How to Select a Worksheet from the Same Workbook?
\n4. How to Activate a Worksheet from the same Workbook?
\n<\/font>\n<\/div>\n

1. How to put some value in an Excel Cell ?<\/h3>\n

This is the most frequently used stuff in excel macro. Reading and writing the data in excel cells. Here are the simple syntax to do so.<\/p>\n

Cells(<\/strong><Row Index> , <Column Index><\/i>).Value = <\/strong><Your Value><\/i>
\nOR<\/strong>
\nRange(<\/strong><Column Name><Row Index><\/i>).Value = <\/strong><Your Value><\/i>
\n <\/p>\n

Steps to Do:<\/h2>\n

1. Open a New Workbook
\n2. Add a Command Button to WorkSheet (
How to Add Command Button in Excel<\/a>)
\n3. Double Click on the Command Button
\n4. Copy and Paste the Below Code in the Command Button Click Event<\/p>\n

\r\nPrivate Sub CommandButton1_Click()\r\n    Range(\"C3\").Value = \"Range C3\"\r\n    Cells(4, 3).Value = \"Row No: 4  Column No: 3\"\r\nEnd Sub\r\n<\/code><\/pre>\n

 
\nNote: In the above you can see that no where Sheet Name is not mentioned. But as you know one Excel Workbook can have many Worksheets and in each worksheets the above Cell Address will exist. Since there is no Sheet Name mentioned, Code will put the value in the Same Sheet where your code or Your Command Button is there. <\/strong><\/font>
\nOn Clicking on Button, Cell C3 and C4<\/strong> will be populated with the Values. Refer the below diagram.<\/p>\n

\"Enter

Enter Value in Cell<\/p><\/div>\n

3. How to read or write some thing in a Excel Cell of a Specified Sheet of the same Workbook.<\/h3>\n

In the above example as you saw that Command button will put the value in specified cell in the same worksheet where Command button is located.
\n 
\nLet’s take an example, you want to put this vale in Same Cell Address but in a Sheet named “MyData”. It means when you click on Command Button, it should Sheet named “My Data” and put these values in that particular cell of that Sheet. <\/p>\n

Follow the below Steps:<\/h3>\n

Under the Command Button Click Event Paste the below Code:<\/p>\n

\r\nPrivate Sub CommandButton1_Click()\r\n    Worksheets(\"My Data\").Range(\"C3\").Value = \"Range C3\"\r\n    Worksheets(\"My Data\").Cells(4, 3).Value = \"Row No: 4  Column No: 3\"\r\nEnd Sub\r\n<\/pre>\n

 
\nNote: <\/strong> Above code will through error if the Sheet Name does not exist in that workbook.
\n<\/p>\n

3. How to Select a Worksheet from the Same Workbook ?<\/h3>\n

Below is the Syntax to select a Particular Worksheet from the Workbook.<\/p>\n

Worksheets(\"Sheet Name\").Select<\/pre>\n

4. How to Activate a Worksheet from the same Workbook ?<\/h3>\n

Below is the Syntax to Activate a Particular Worksheet from the Workbook.<\/p>\n

Worksheets(\"Sheet Name\").Activate<\/pre>\n
\nTo Check out more Excel Macro Tutorials, visit Excel Macro Tutorial<\/a><\/strong>
\nTo Check out more Excel Tips and Tricks, visit
Excel Tips and Tricks<\/a><\/strong>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"

Let’s take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use them. You have also learned How […]<\/p>\n","protected":false},"author":45,"featured_media":242487,"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":[1679,1676,5204],"tags":[],"class_list":["post-12142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-macro-beginner","category-excel-tips","category-vba-programming"],"yoast_head":"\nExcel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding) - Let's excel in Excel<\/title>\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\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)\" \/>\n<meta property=\"og:description\" content=\"Let’s take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use them. You have also learned How […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\" \/>\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=\"2012-06-10T10:05:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:17:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"558\" \/>\n\t<meta property=\"og:image:height\" content=\"451\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)\",\"datePublished\":\"2012-06-10T10:05:04+00:00\",\"dateModified\":\"2022-08-12T11:17:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\"},\"wordCount\":574,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png\",\"articleSection\":[\"Excel Macro Beginner\",\"Excel Tips\",\"VBA Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\",\"name\":\"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding) - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png\",\"datePublished\":\"2012-06-10T10:05:04+00:00\",\"dateModified\":\"2022-08-12T11:17:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png\",\"width\":558,\"height\":451,\"caption\":\"Enter Value in Cell\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro Beginner\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)\"}]},{\"@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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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:\/\/x.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 Tutorial : Basics of VBA (Basic Syntaxes required while coding) - Let's excel in Excel","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\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","og_locale":"en_US","og_type":"article","og_title":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)","og_description":"Let’s take a brief recap of all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learned about all the Controls available in Excel Macros and also how to use them. You have also learned How […]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","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":"2012-06-10T10:05:04+00:00","article_modified_time":"2022-08-12T11:17:46+00:00","og_image":[{"width":558,"height":451,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png","type":"image\/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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)","datePublished":"2012-06-10T10:05:04+00:00","dateModified":"2022-08-12T11:17:46+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/"},"wordCount":574,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png","articleSection":["Excel Macro Beginner","Excel Tips","VBA Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","url":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","name":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding) - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png","datePublished":"2012-06-10T10:05:04+00:00","dateModified":"2022-08-12T11:17:46+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/Value_In_Cell2-1.png","width":558,"height":451,"caption":"Enter Value in Cell"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro Beginner","item":"https:\/\/vmlogger.com\/excel\/excel-macro-beginner\/"},{"@type":"ListItem","position":3,"name":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)"}]},{"@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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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:\/\/x.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\/12142"}],"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=12142"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242487"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}