Excel Macro Class 3 - Looping through Ranges & Working with Cells

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

Excel Macro Class 3 - How to loop through ranges of data and work with the cells in those ranges.

This includes:
- how to loop through a row of data.
- how to loop through a column of data.
- how to loop through all rows and columns of a range of data.
- how to get values from the cells within the ranges.
- how to access any data point about the cells in the ranges.
- how to use IF statements to make logical checks within the loop.

This tutorial covers the For Next Each loop.

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[georgekammar]

This is the best excel channel out there. Good job man.

[adumcoca]

spent two hours fumbling on a loop, then found this and fixed it in 5 seconds. thanks!

[bmkucuk]

I've watched lots of videos for to learn VBA for beginners, and your video is by far the best. You are very good to teach something, congratulation, Thank you for your videos

[scottgaines]

Great video! You explained the for each loop very well. Things make more sense now. Appreciate it!

[graememcgregor]

I need to see this a few times! For me it has gone from dead simple to pretty complex.

[shenay]

Thank you for explaining this in a very simple way. Everything makes sense. You're awesome!

[bogamcs]

I love your voice and style. It's like listing to Salman Khan on Khan Academy. Thanks for the tutorials!

[koyelbhattacharjee]

Your tutorials are really awesome and very elaborate.
Great!
Cheers!

[TheMrDrinken]

Best excel courses on the net.
Thank you!

[shivkumarr]

exhausting but run once or twice and you have it clear.

[Tawvx]

Quality content 🙏
Thank you very very very very much sir

[avpproduction]

Thank you for making my life easy.. god bless

[xiaoyuwang]

Great video! So helpful for my job hunting preparation.

[Toitoikoi]

thank you so much you explain so neat its just easy to understand ..

[noobnoob]

Thank you for your enthusiasm on teaching this topic. Youve been helpful

[hazemali]

please we need more and more videos for VBA we need to know how make business (handle massive date )with VBA

[gerardvaneggermond]

Hello sir, I found it interesting even though I don't fully understand it, maybe you can help me, I made code but it's long, can you help me make it smaller?

[tannertucker]

Excellent. I purchase many of the Udemy courses, but yours are presented better and more logically. Thank you. I would love love to know how to loop through a range AND compare a value in the range (let's say in column B) to a named range (a list of postal codes). If the row's column B value matches any of the values in the named range then do something. Any direction would be greatly appreciated. Thank you again.

[TanvirMostofa]

Dear brother, I want to know how to solve the three criteria against floor value index match function in visual basic ? Can i shear a excel file.