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