{"id":1191,"date":"2012-01-12T19:09:28","date_gmt":"2012-01-12T19:09:28","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1191"},"modified":"2017-07-11T20:50:07","modified_gmt":"2017-07-11T20:50:07","slug":"for-loop-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/01\/for-loop-excel-macro\/","title":{"rendered":"Excel Macro Tutorial : For Next Loop in Excel Macro"},"content":{"rendered":"
[fullwidth background_color=”” background_image=”” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” border_color=”” border_style=”” padding_top=”20″ padding_bottom=”20″ padding_left=”” padding_right=”” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no” menu_anchor=”” class=”” id=””][one_full last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=””][title size=”1″ content_align=”left” style_type=”underline solid” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]Beginners guide for how to use\u00a0FOR Loop in Excel VBA[\/title][fusion_text]Keeping the beginners in mind, I am going to write this article about For Next loop<\/strong> in Excel Macro. Also one of my friend wanted such post to be published. First of all i would like to thank for such input and feedback. Even if you want any help or any article to be published, kindly mail me.<\/strong><\/a><\/p>\n If you want to learn Excel Macros then read articles from Excel Macro Tutorial<\/a><\/strong><\/p>\n So coming to the Article, mainly there are following Types of Loops which are used.<\/p>\n In this Article, I am going to Explain you about For Next Loop. For Other Two loops While and Do While Loop<\/strong>, you can refer the next article.<\/a><\/strong><\/p>\n <\/a> Since it is a loop, it requires<\/p>\n 1. An Index or Incremental variable which counts the total number of iterations after completion of each iteration..<\/p>\n 2. Such a condition where this loop should end.<\/p>\n Note:<\/strong> Be careful with this condition. If it is such a condition which may never end, then it is infinite loop and your program will crash.\n
\n[\/fusion_text][\/one_full][title size=”1″ content_align=”left” style_type=”underline solid” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]How to use FOR Loop in Excel VBA[\/title][fusion_text]In this Article you will learn about For Next loop.<\/strong> This is the most frequently used loop. It enables you to execute a set of VBA statements multiple number of iterations.<\/p>\n
\n<\/em>[\/fusion_text][title size=”2″ content_align=”left” style_type=”underline solid” sep_color=”” margin_top=”” margin_bottom=”” class=”” id=””]FOR LOOP Syntax in Excel VBA[\/title][fusion_text]<\/p>\n