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.

#Excel #ExcelTips #ExcelTutorial

[dlee]

Thanks for the video. I really like the way you explain; it's not like driver training on the autobahn. Is there a format where I can ask a more in-depth question?

[christianfarfan]

Good stuff there man! Keep it up.
Quick question man, any webpage u recommend to practice? I mean, some exercises online.

Thank you in advance! Already subscribed

[kannanravishankar]

Hi Master, hope you are doing well!
The protect code will block all the sheets in excel 2016 version. Please advise.

[josanamadis]

Can you help me SIr. The query is:: I have a range V1:V6091. I want a vba code so that each value from this range should be pasted one by one in cell B5 in same sheet. Then, each paste converts the active worksheet(Dashboard) into pdf(by name in cell B5).

[rochmajungreis]

you dont need a password to protect sheets?

[nachoo]

I protected my page and now I cannot desprotect it