<\/p>\n
The For Loop is perhaps<\/strong> the most useful of all the Loops. It runs a line or lines of code a set amount of times in any increment we set. The default increment is one. As you can see from below you must<\/strong> use a Variable of the Numeric type to set the amount of Loops it will perform.<\/p>\n <\/p>\n <\/p>\n Sub My_For()<\/p>\n Dim iMyNumber as Integer<\/p>\n <\/p>\n For<\/strong> iMyNumber= 1 To 100<\/p>\n iMyNumber=1+iMyNumber<\/p>\n Range(“b2”).Value = iMyNumber<\/p>\n Next <\/strong>iMyNumber<\/p>\n <\/p>\n End Sub<\/p>\n <\/p>\n <\/p>\n The other great part about the For<\/strong> Loop is we can increment by any Value we like. We do this by using the Step Key word and telling it the Step (or increment) to use. so we could use:<\/p>\n <\/p>\n Sub My_For1()<\/p>\n Dim iMyNumber as Integer<\/p>\n Dim iMyNumber2 as Integer<\/p>\n <\/p>\n For<\/strong> iMyNumber= 1 To 100 Step 2<\/p>\n iMyNumber2 =1+iMyNumber2<\/p>\n Next<\/strong> iMyNumber<\/p>\n <\/p>\n Range(“b2”).Value = iMyNumber<\/p>\n <\/p>\n End Sub<\/p>\n By doing this we will Loop through our code 51<\/strong> times instead of 101 times, but the Variable iMyNumber will end up with a Value of 101.<\/p>\n <\/p>\n We could also use the Step Key word to work backwards like below:<\/p>\n Sub My_For2()<\/p>\n Dim iMyNumber as Integer<\/p>\n Dim iMyNumber2 as Integer<\/p>\n <\/p>\n For<\/strong> iMyNumber= 1000 To 1 Step -1<\/p>\n iMyNumber2 =1+iMyNumber2<\/p>\n Next<\/strong> iMyNumber<\/p>\n Range(“b2”).Value = iMyNumber<\/p>\n <\/p>\n End Sub<\/p>\n <\/p>\n This would mean that our Variable iMyNumber would end up with a Value of 0 (Zero).<\/p>\n","protected":false},"excerpt":{"rendered":" The For Loop is perhaps the most useful of all the Loops. It runs a line or lines of code a set amount of times in any increment we set. The default increment is one. As you can see from below you must use a Variable of the Numeric type to set the amount … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-137","post","type-post","status-publish","format-standard","hentry"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":1,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"predecessor-version":[{"id":888,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/posts\/137\/revisions\/888"}],"wp:attachment":[{"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/99excel.com\/home\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}