Explain about Loops

     

  • Looping the process of repetition
  • Through this process we can execute the repeatedly same statement

    •  

    What is meant by ITERATION of Loop

     

  • Completion of one comple cycle of executing the statement termed as ITERATION

    •  

     

  • Based on number of ITERATIONS we can classify the loops in two

    •  

    1)Fixed Loop

    2)Flexible Loop

     

     

  • Fixed Loop: In case of fixed loops number of iterations are fixed, irrespective of statement condition

    •  

  • Ex: Repeat the loop 15 times, i.e it is fixed and pre determined

    •  

  • Flexible Loop: In case of Flexible loops number of iterations are variable, iteration depends on satisfaction of condition

    •  

  • Do Until Condition is met: Iterate upto cell value is becomes 85, upto blank cell

    •  

  • Do while condition satisfied\Exists:Color 11 cells

    •  

    If function and Loops are heart to VBA

     

    What is meant by Loop Determinant\Loop Variant

     

  • Loop determinant is a expression which indicates about how many times loop repeats

    •  

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli