Excel VBA Introduction Part 16 - For Next Loops

By Andrew Gould

[marinmarelja]

Das war wirklich sehr gut. Habe mich lange gefragt, wie man range mit for verbinden kann. cells mit for war kein Problem. Vielen Dank für deine Arbeit.

[guthrie_the_wizard]

Just donated as a thank you! I would encourage anyone that feels they have gotten a lot of value to do the same.

[maurocastagnera]

Dear Andrew, it is really a pleasure to watch your videos and listen to your voice. At this time it's 8.15 p.m. on Saturday but I can not get out of the pc because every minute passes you teach me something new on the VBA. I really do not have any more words to thank you. You are really an excellent teacher. Thanks for all that I am learning from you!

[BigWes]

Appreciate so much that you've put these videos on YouTube for free. I payed a decent whack for an online course that is a pile of horseshit compared to your videos. Always very thorough and extremely well explained.

[jamarsyn]

Your tutorials are outstanding. You are an excellent teacher.

[thomaswashington]

For Efficient Reference:
The Syntax of a For Next Loop :41
The Step Keyword 3:30
Exiting from a for Next Loop 5:11
Looping Over Worksheets 6:56
Looping Over Workbooks 11:47
Looping Over Cells 16:38

[larrykent]

Again outstanding VBA training video, thank you.

[ksujithkarun]

Excellent video. Though I have gone through several other training materials, the concept of For - Next loop has never been clearer to me.

Thanks for creating & sharing this...

[nadermounir]

Thank you very much Andrew. Great video 📹 👍

[wasimbader]

THANK YOU FOR THIS ONE. GREAT JOB ANDREW. THUMBS UP

[Tat-cxlr]

Merci pour le conseil. Encore une fois vos vidéos sont excellentes et très utiles.

[tristanquintus]

Thanks - a very useful video that I am sure I will utilize...

[morsheddld]

Awesome video
i appreciate you for your contribution to #Excel Training.
i must say, this video is pretty much useful for the beginners like us.

[samuelkingston]

Very useful & easy to learn. Excellent.

[houstonvanhoy]

Hello, fellow viewers.

Andrew (correctly) does not like to use ancient variable names "i" and "j" and "k", left over from 1970s mainframe programming practices. If anyone questions you about declaring a variable named "LoopCounter" instead of "i", just reply that you are not programming in Fortran. And if you are feeling feisty, you might add: "How old are you, anyway?"

[mohamedelmoslmany]

how to copy the result (for/next) to anothere sheet

[Mirelinin]

18:02 - could you please explain why have you chosen the bottom of your list A2, when the bottom of your list is A14? Also, if I specify A14 as the bottom of my list, the macro goes absolutely nuts and crashes my excel :D. On the other hand, if I choose A13 as the bottom, then it works just fine.

[NFarooq]

Hi, thanks for your videos they have been incredibly helpful!

I notice you have done the 'Rate All Films' example using a For Next loop in this video, and a Do Until Loop in a previous video. For practical purposes, which would be better to use and why?

Thanks again

[shelleyprice]

Hi Andrew. First let me start by saying that I have watched a number of your videos (some more than once) and I am very impressed with your ability to explain seemingly complicated information. Secondly, I should mention that I am very new to VBA Excel and have a complicated task at hand which I am hoping you can help me with. I am processing a set of data using Case Select statements and then sorting (by copying) that information to new sheets within the same worksheet- similar to what you did with film length (short, medium, long into new tabs). This is fine and dandy- no problems. What I wish to do then is to have that "loop" process through most of the sheets in the workbook (excluding the "new sheets" which have been copied into). I have been attempting to do this using a "For each/ Next" statement and using the index number of the sheets, but I am apparently not skilled enough to do so. Any advice would be greatly appreciated!

[Blazer]

nice video. I have a question: how can i make my own npv & irr function?