{"id":14695,"date":"2018-04-02T17:36:47","date_gmt":"2018-04-02T17:36:47","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14695"},"modified":"2022-08-17T19:18:11","modified_gmt":"2022-08-17T19:18:11","slug":"how-to-comment-a-line-or-group-of-lines-in-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/","title":{"rendered":"3 Methods to Comment or Uncomment in Excel VBA"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ _module_preset=”default” global_colors_info=”{}”]Dear Friends,<\/p>\n

This is a very simple yet useful article, especially for beginners. Sometimes even intermediate-level users also do not know about all these options to comment on a line or group of lines in Excel VBA.<\/p>\n

Like every other programming language, VBA too has an option to comment on a line or group of lines in your code.
\nFor those who does not know – what is comment in a Programming:<\/em><\/span><\/p>\n

Commenting a line or group of lines in any programming language means – to instruct the execution control or compiler to skip those lines from compilation or execution. <\/em><\/p>\n

Before I tell you how to comment on a line in Excel VBA, let me explain to you – the use of it<\/p>\n

\n

What is the use of comments in Excel VBA Programming<\/h2>\n

As mentioned above these comments is something that is not compiled or executed, a programmer can write anything in any simple human language to give a brief description of a function, a variable, a statement, etc.
\nThis makes the programmer’s life easier from a maintenance perspective. By reading those brief descriptions of the code, any programmer can have a basic idea of what that function or statement or variable, etc. does.<\/p>\n

It is not MANDATORY but a good programming practice to provide proper comments so that any other programmer can easily understand the code easily.<\/p>\n<\/div>\n

How to comment a single line in VBA code <\/h1>\n

Basically, there are 3 ways to do so. <\/p>\n

Method 1: Using Single Quote (‘) <\/h2>\n

This is one of the simplest methods to comment on a single line in VBA programming.
\nTo comment on a line, you can simply type a single quote (‘)<\/span> at the beginning of that line. The whole line will turn into green text. That’s all!
\nNow that line would neither be compiled nor executed. <\/p>\n

\"To

To Comment a line in VBA<\/p><\/div>\n

Note:<\/h3>\n

A single quote can be put somewhere in the middle of a line as well. In such case, rest of the text after the single quote (‘)<\/span> will be treated as comment.
\nRefer to the below image
\n

\"Comment<\/a>

Comment Line in VBA<\/p><\/div><\/p>\n

Method 2: Using REM<\/code> Keyword in Excel VBA <\/h2>\n

This is also a simple one but I do not prefer this. You can see the reason below in the note section. <\/p>\n

To comment on any line in VBA you can start that line with the keyword REM <\/code> So in this method, instead of a single quote (apostrophe) you can type the Rem keyword. <\/p>\n

\"Rem

Rem Keyword to comment a line<\/p><\/div>\n

Note:<\/h3>\n

Following are the limitation using this Rem keyword
\n1.<\/em> There should be at least one space between the start of your comment and the Rem keyword.
\n2.<\/em> Like a single quote, the Rem keyword can not be used in the middle of a line to comment rest of the line. Rem keyword must always be the first word to start with.<\/p>\n

I think the above two reasons are more than enough for me not to like it :). <\/p>\n

Method 3: VBE built-in Option – Comment\/Uncomment Block <\/h2>\n

This is the same method as the first one, but here you do not need to type a Single quote by yourself, rather you can follow the below steps:
\n1.<\/em> Place your mouse cursor anywhere on the line on which you want to comment
\n2.<\/em> Press on “Comment” button as shown in below video<\/p>\n

\"Toggle

Toggle between comment and un-comment<\/p><\/div>\n

\n

Important:<\/h3>\n

Using this method you also get an option to press the “Uncomment” button as well as shown in the above gif video.<\/p><\/div>\n

How to comment or un-comment multiple lines together <\/h1>\n

Unfortunately in VBA, there is no shortcut key to do so. But don’t worry, method 3 is very useful in this case.
\nYou can use the same buttons Comment Block and Un-comment Block <\/em><\/span> to do this.
\nSimply select all the lines you want to comment on or uncomment it and press the relevant button as shown below:<\/p>\n

1# How to comment group of lines (Block) in VBA <\/h2>\n

Step 1:<\/em> Select all the lines (block)
\nStep 2: <\/em>Press the Comment Block<\/span> as shown in above picture<\/p>\n

\"Comment

Comment Uncomment VBA Methods<\/p><\/div>\n

2# How to Un-comment group of lines (Block) in VBA <\/h2>\n

Step 1:<\/em> Select all the commented lines (block)
\nStep 2: <\/em>Press the Uncomment Block<\/span> as shown in above picture<\/p>\n

\"Comment

Comment Uncomment VBA Methods<\/p><\/div>\n

What if Comment Block and Uncomment Block Button not visible<\/h3>\n

Follow the below steps:
\nStep 1:<\/em> Go to View –> Toolbars –> Edit<\/p>\n

\"VBE<\/a>

VBE – View Edit Option<\/p><\/div>
\nStep 2: <\/em>Check the Edit option. You will see the Edit toolbar where you can find these two options along with others.<\/p>\n

\"Comment-uncomment-button\"<\/a>

Comment-uncomment-button<\/p><\/div>[\/et_pb_text][et_pb_blurb title=”Few more interesting tips:” use_icon=”on” font_icon=”||fa||400″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

    \n
  1. Excel VBA Tips: How to comment or uncomment a Block of code<\/a><\/li>\n
  2. Read and Write Document Properties of an excel Document<\/a><\/li>\n
  3. Excel Tip: How to refer characters using ASCII Value<\/a><\/li>\n
  4. Hide Group outline symbol in Excel – [Manual Option + VBA]<\/a><\/li>\n
  5. Excel VBA Tip – Expand \/ Collapse all the Groups in Excel<\/a><\/li>\n<\/ol>\n

    [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

    Dear Friends, This is a very simple yet useful article, especially for beginners. Sometimes even intermediate-level users also do not know about all these options to comment on a line or group of lines in Excel VBA. Like every other programming language, VBA too has an option to comment on a line or group of […]<\/p>\n","protected":false},"author":45,"featured_media":242607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1676,5204],"tags":[],"class_list":["post-14695","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips","category-vba-programming"],"yoast_head":"\n3 Methods to Comment or Uncomment in Excel VBA - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in 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:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Methods to Comment or Uncomment in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in VBA\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\" \/>\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=\"2018-04-02T17:36:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-17T19:18:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"3 Methods to Comment or Uncomment in Excel VBA\",\"datePublished\":\"2018-04-02T17:36:47+00:00\",\"dateModified\":\"2022-08-17T19:18:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\"},\"wordCount\":1019,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png\",\"articleSection\":[\"Excel Tips\",\"VBA Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\",\"name\":\"3 Methods to Comment or Uncomment in Excel VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png\",\"datePublished\":\"2018-04-02T17:36:47+00:00\",\"dateModified\":\"2022-08-17T19:18:11+00:00\",\"description\":\"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in VBA\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png\",\"width\":800,\"height\":538,\"caption\":\"Comment and Uncomment in - Excel VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tips\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-tips\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"3 Methods to Comment or Uncomment in Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@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":"3 Methods to Comment or Uncomment in Excel VBA - Let's excel in Excel","description":"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in 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:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"3 Methods to Comment or Uncomment in Excel VBA","og_description":"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in VBA","og_url":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/","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":"2018-04-02T17:36:47+00:00","article_modified_time":"2022-08-17T19:18:11+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"3 Methods to Comment or Uncomment in Excel VBA","datePublished":"2018-04-02T17:36:47+00:00","dateModified":"2022-08-17T19:18:11+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/"},"wordCount":1019,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png","articleSection":["Excel Tips","VBA Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/","url":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/","name":"3 Methods to Comment or Uncomment in Excel VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png","datePublished":"2018-04-02T17:36:47+00:00","dateModified":"2022-08-17T19:18:11+00:00","description":"How to comment group of lines in VBA? Uncomment VBA code block. What is REM keyword in Excel VBA? 3 Methods to comment and uncomment multiple lines of VBA code. What is comment in VBA? How to comment VBA lines? What is the use of comments in Excel VBA? Shortcut method to comment group of lines in VBA","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Comment-and-Uncomment-in-Excel-VBA.png","width":800,"height":538,"caption":"Comment and Uncomment in - Excel VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/how-to-comment-a-line-or-group-of-lines-in-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Tips","item":"https:\/\/vmlogger.com\/excel\/excel-tips\/"},{"@type":"ListItem","position":3,"name":"3 Methods to Comment or Uncomment in Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@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\/14695"}],"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=14695"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14695\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242607"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=14695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=14695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=14695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}