$$Excel-Macros$$ Please explain about loop
Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Please explain about loop
Are you refering to loop while,or loop until? 2011/7/25 neil johnson neil.jh...@googlemail.com Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Please explain about loop
Using Do...Loop Statementshttp://office.microsoft.com/client/helppreview.aspx?AssetId=HV805564959990lcid=1033NS=EXCEL%2EDEVVersion=12pid=CH080556468CTT=4 Article you can use Do...Loop statements to run a block of statements an indefinite number of times. The statements are repeated either while a condition is True or unt... Using For Each...Next Statementshttp://office.microsoft.com/client/helppreview.aspx?AssetId=HV805564969990lcid=1033NS=EXCEL%2EDEVVersion=12pid=CH080556468CTT=4 Article For Each...Next statements repeat a block of statements for each object in a collection or each element in an array . Visual Basic automatically sets a variable... Using For...Next Statementshttp://office.microsoft.com/client/helppreview.aspx?AssetId=HV805564979990lcid=1033NS=EXCEL%2EDEVVersion=12pid=CH080556468CTT=4 Article You can use For...Next statements to repeat a block of statements a specific number of times. For loops use a counter variable whose value is increased or decre... http://www.excel-vba-easy.com/vba-programming-excel-vba-loop.html http://www.databison.com/index.php/vba-for-loop-for-next-and-for-each-in-next/ -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Jul 25, 2011 at 9:24 PM, neil johnson neil.jh...@googlemail.comwrote: Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Please explain about loop
Hi Jorge, all loop which used in excel sheet On Mon, Jul 25, 2011 at 9:55 PM, Jorge Marques leote.w...@gmail.com wrote: Are you refering to loop while,or loop until? Hi 2011/7/25 neil johnson neil.jh...@googlemail.com Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Please explain about loop
See the attached File : Sub FLoop() Dim i As Integer Range(A1).Value = Example By For Loop Range(A2).Select For i = 1 To 20 ActiveCell.Value = i am In For Loop i time and My value is i ActiveCell.Offset(1, 0).Select Next End Sub Sub DoLoop() Dim i As Integer Range(A1).Value = Example By Do Loop Range(A2).Select i = 0 Do i = i + 1 ActiveCell.Value = i am In Do Loop i time and My value is i ActiveCell.Offset(1, 0).Select Loop Until i = 20 End Sub Sub WhileLoop() Dim i As Integer Range(A1).Value = Example By While Loop Range(A2).Select i = 0 While i 20 i = i + 1 ActiveCell.Value = i am In While Loop i time and My value is i ActiveCell.Offset(1, 0).Select Wend End Sub Sub LableLoop() Dim i As Integer Range(A1).Value = Example By lable and Goto Range(A2).Select i = 0 CC: i = i + 1 ActiveCell.Value = i am In Goto Loop i time and My value is i ActiveCell.Offset(1, 0).Select If i 20 Then GoTo CC: Else Exit Sub End If End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Monday, July 25, 2011 9:24 PM To: excel-macros Subject: $$Excel-Macros$$ Please explain about loop Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Loop Example.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12