Free Excel VBA Course #19 - FOR EACH Loop in Excel VBA

In this video, I will show you how to insert and use the FOR EACH loop in Excel VBA. In VBA, you can loop through a set of collections using the ‘For Each’ loop. Here are some examples of collections in Excel VBA: -- A collection of all the open Workbooks. -- A collection of all worksheets in a workbook. -- A collection of all the cells in a range of selected cells. -- A collection of all the charts or shapes in the workbook. -- Using the ‘For Each’ loop, you can go through each of the objects in a collection and perform some action on it. For example, you can go through all the worksheets in a workbook and protect these, or you can go through all the cells in the selection and change the formatting. ✅ VBA Course Download files: https://trumpexcel.com/course-downloa... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... ------------------------------------------------------------------------------------- 00:00 - Introduction to For Each loops 01:00 - For Each vs. For Next loop differences 01:44 - For Each loop syntax and structure 02:35 - Example: Looping through cell range 03:42 - Looping through different object collections 04:11 - Example: Looping through worksheets 05:42 - Protecting all sheets with For Each loop ------------------------------------------------------------------------------------- #excelvba #ExcelTips #ExcelTutorial