{"id":13749,"date":"2018-04-22T16:30:24","date_gmt":"2018-04-22T16:30:24","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=13749"},"modified":"2022-08-17T19:17:34","modified_gmt":"2022-08-17T19:17:34","slug":"5-most-unused-tricks-in-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/","title":{"rendered":"5 rarely used features 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

As promised last week, in this article, I am going to talk about 5 rarely used features of Excel VBA. [I am not saying that all of these features are awesome to use… I have provided my personal choices for each of them]<\/p>\n

1# Using IIF in Excel vba<\/h1>\n

IIF is a type of IF ELSE END IF. Of course, it is not exactly the same as a normal if-else statement.<\/p>\n

Syntax of IIF Statement<\/em><\/p>\n

IIF(Expression to check, value if true, value if false )<\/code><\/pre>\n

As you can see this, it pretty much looks like If, do this, else do this<\/em>. But this is not the same as the If else statement.<\/p>\n

Difference between If-Else and IIF<\/h2>\n
    \n
  1. In If-else, else part is not mandatory. You can write an If statement even without any else blocks whereas in IIF both – true and false values are mandatory to provide. You can skip either of them.<\/li>\n
  2. In If-else, If condition expression is true then – Code inside IF block is evaluated and executed and Else Block is completely ignored. Whereas in IIF, both the expressions [value if true part] and [value if false part] are evaluated even though only one is executed at a time.<\/em> Therefore you should be careful while using this statement to evaluate some conditions.<\/li>\n<\/ol>\n
    \n

    Note:<\/h3>\n

    2nd difference mentioned above is one of the main differences between the If Else and IIF statements. This is also one of the main reasons – I do not prefer<\/em> to use this more often.<\/p>\n<\/div>\n

    Above explanation will be more clear with the following example.<\/p>\n

    \nSub IIF_Demo()\n\nDim x As Integer\nDim y As Integer\nDim div As Integer\nx = 0\ny = 2\nIIf x <> 0, div = y \/ x, div = 0\nDebug.Print div\nEnd Sub\n\n\n<\/code><\/pre>\n

    Note: <\/em>Above program will throw a run time error divide by zero error<\/em>. As mentioned above, even though condition x is not equal to zero – true and code should execute div = 0, it will also evaluate div = y\/x expression as well and therefore this error.<\/p>\n

    Same logic is written using If Else in the below code and it will run successfully without any error.<\/p>\n

    \nSub IFELSE_Demo()\nDim x As Integer\nDim y As Integer\nDim div As Integer\nx = 0\ny = 2\nIf (x <> 0) Then\n    div = y \/ x\nElse\n    div = 0\nEnd If\nDebug.Print \"If Else executed and div value is calculated... div = \"; div\nEnd Sub\n<\/code><\/pre>\n

    2# End If is not always mandatory for If statement<\/h1>\n

    If you can type your IF and\/or Else statement(s) in single line as shown below then you do not need to type End If.<\/p>\n

    \n Sub IfWithoutElseDemo()\n    Dim a As Integer\n    Dim b As Integer\n    a = 1\n    b = 2\n    If (a > b) Then MsgBox a Else MsgBox b\nEnd Sub\n<\/code><\/pre>\n

    Remarks:<\/em> Personally I prefer this only when
    \n1. There is no Else part in If Statement
    \n2. Single statement is executed as part of If<\/p>\n

    If any of the above criteria is not met, then I prefer using the If and End If – Complete set. This is my personal preference<\/>. This is also because it makes the code more readable else it will be difficult to read the If Else part. <\/em><\/p>\n

    3# Colon in VBA as – End of Statement<\/h1>\n

    As you know in VBA new line itself is considered the end of the statement. Therefore, if you want to type multiple statements in a single line then you can use a colon as the end of a statement in VBA.<\/p>\n

    \nSub ColonAsEndOfStatement()\n    Dim a As Integer\n    Dim b As Integer\n    a = 1\n    b = 2\n    If (a > b) Then MsgBox \"Line 1\": MsgBox \"Line 2\": MsgBox \"Line 3\" Else MsgBox \"Else part 1\": MsgBox \"Else part 2\"\nEnd Sub\n<\/code><\/pre>\n

    Note:<\/em> Personally I do not like this at all. I prefer each statement written in a new line. Using multiple statements in a single line using a colon reduces the code readability drastically.<\/p>\n

    4# Using immediate window and Debug statement<\/h1>\n

    This is one of my favorite features of Excel VBA. <\/em> To know more about this, I have written a detailed article about this. Read this article to know more about:
    \nWhat is immediate window? <\/a>
    \n
    What is Debug command and how to use it? <\/a><\/p>\n

    5# Replace text in a String using mid function<\/h1>\n

    Using Mid function, you can replace text in a string.<\/p>\n

    \nSub replaceTextUsingMid()\n    Dim inputStr As String\n    inputStr = \"Excel is logical\"\n    Mid(inputStr, 10, 2) = \"ma\"\n    MsgBox inputStr\nEnd Sub\n<\/code><\/pre>\n

    Result:<\/h3>\n

    The above code will result in the following message box with Text – “Excel is magical”<\/p>\n

    Note:<\/h3>\n

    Integer Length specified in the Mid function should be the same as the length of the string which you want to replace it with. For example, in the above code, I have used 2 <\/em>in mid function and length of string ma<\/em> is also 2.<\/p>\n

    In case these two are not equal, the expression will not throw any error. It will simply take the lowest of both and does its job.<\/p>\n

    Example 1:<\/em>
    \nFollowing will result – Excel is magical<\/em><\/p>\n

    \n    inputStr = \"Excel is logical\"\n    Mid(inputStr, 10, 3) = \"ma\"\n<\/code><\/pre>\n

    Example 1:<\/em>
    \nFollowing will result – Excel is magical<\/em><\/p>\n

    \n    inputStr = \"Excel is logical\"\n    Mid(inputStr, 10, 2) = \"man\"\n<\/code><\/pre>\n

    [content_boxes layout=”icon-on-side” columns=”1″ backgroundcolor=”#F4EB94″ ][content_box title=”Important Info” icon=”” backgroundcolor=””]This method can be used effectively when you want to replace some fixed number of characters located at some specific location in a given string irrespective of what those strings are.
    \nIn this case VBA.Replace() <\/em>is not useful because to use this Replace() function – you need to know what exactly the string is at a given location in a string to replace.<\/p>\n

    So this is a useful feature that can be used effectively in a particular situation.[\/content_box][\/content_boxes][\/et_pb_text][et_pb_blurb title=”You may like reading them too” use_icon=”on” font_icon=”||fa||900″ _builder_version=”4.17.6″ _module_preset=”0249c68e-4de8-4f44-84ff-a9b1850785b6″ hover_enabled=”0″ global_colors_info=”{}” content__hover_enabled=”off|desktop” sticky_enabled=”0″]<\/p>\n

      \n
    1. VBA Guide to Interact with Text Files \u2013 Part \u2013 1 of 2<\/a><\/li>\n
    2. VBA Guide to Interact with Text Files \u2013 Part \u2013 2 of 2<\/a><\/li>\n
    3. Download : Excel Macro Application to Send Multiple Emails<\/a><\/li>\n
    4. Regular Expression and its usage in Excel VBA<\/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, As promised last week, in this article, I am going to talk about 5 rarely used features of Excel VBA. [I am not saying that all of these features are awesome to use… I have provided my personal choices for each of them] 1# Using IIF in Excel vba IIF is a type […]<\/p>\n","protected":false},"author":45,"featured_media":242631,"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":[1246,1679],"tags":[],"class_list":["post-13749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-macro-beginner"],"yoast_head":"\n5 rarely used features in Excel VBA - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.\" \/>\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\/5-most-unused-tricks-in-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 rarely used features in Excel VBA\" \/>\n<meta property=\"og:description\" content=\"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-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-22T16:30:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-17T19:17:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg\" \/>\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\/jpeg\" \/>\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=\"5 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\/5-most-unused-tricks-in-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"5 rarely used features in Excel VBA\",\"datePublished\":\"2018-04-22T16:30:24+00:00\",\"dateModified\":\"2022-08-17T19:17:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/\"},\"wordCount\":972,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Beginner\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/\",\"name\":\"5 rarely used features in Excel VBA - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg\",\"datePublished\":\"2018-04-22T16:30:24+00:00\",\"dateModified\":\"2022-08-17T19:17:34+00:00\",\"description\":\"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg\",\"width\":800,\"height\":538,\"caption\":\"5 Rarely used features of Excel VBA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"5 rarely used features 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":"5 rarely used features in Excel VBA - Let's excel in Excel","description":"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.","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\/5-most-unused-tricks-in-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"5 rarely used features in Excel VBA","og_description":"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.","og_url":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-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-22T16:30:24+00:00","article_modified_time":"2022-08-17T19:17:34+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg","type":"image\/jpeg"}],"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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"5 rarely used features in Excel VBA","datePublished":"2018-04-22T16:30:24+00:00","dateModified":"2022-08-17T19:17:34+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/"},"wordCount":972,"commentCount":3,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg","articleSection":["Excel Macro","Excel Macro Beginner"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/","url":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/","name":"5 rarely used features in Excel VBA - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg","datePublished":"2018-04-22T16:30:24+00:00","dateModified":"2022-08-17T19:17:34+00:00","description":"5 Rarely used Excel VBA features. What is IIF function in VBA? Difference between IF and IIF in VBA. What is intermediate window in VBA. How to use Mid function in VBA. 5 Interesting functions in VBA. How to write multiple statements in single line in VBA. Get to know more interesting VBA features here i this article.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2018\/04\/Rarely-Used-Features-in-Excel-VBA.jpeg","width":800,"height":538,"caption":"5 Rarely used features of Excel VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2018\/04\/5-most-unused-tricks-in-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"5 rarely used features 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\/13749"}],"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=13749"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/13749\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/242631"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=13749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=13749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=13749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}