Learn MS Excel – Video 374- VBA – Case Study -Loop in Loop – Collection and DO For Next Loops



In this video we are using collection loops with for next and do loops. See how you can write sub loops within loops and how powerful code can be if you have a sound knowledge to loops

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

3 thoughts on “Learn MS Excel – Video 374- VBA – Case Study -Loop in Loop – Collection and DO For Next Loops

  1. Very nice sir.. Thank u so much… 2017 was grt for me in terms of learning.. Wish u Happy & prosperous New Year.. & please uploading such amazing videos in 2018 as well… Tc

  2. Ajay nice video!!

    i have also done below cited coding for the same but it snot giving the desired results
    i think due to concatenation, could you pl suggest how to apply concatenation.

    Sub serialnumber()
    Dim ws As Worksheet, j As Integer, i As Integer
    j = 1: i = 1

    For Each ws In Worksheets

    Do while B&"i+1" <> ""

    Range("A" & "i+1").Value = i
    i = i + 1

    Loop

    Next

    End Sub

    Pl also suggest in case any other correction is required……

Leave a Reply

Your email address will not be published. Required fields are marked *