How To Master The For/Next Loop | Excel VBA For Beginners

[@ExcelForFreelancers]

🎄 𝗦𝗮𝘃𝗶𝗻𝗴𝘀 𝗔𝘀 𝗕𝗿𝗶𝗴𝗵𝘁 𝗔𝘀 𝗖𝗵𝗿𝗶𝘀𝘁𝗺𝗮𝘀 𝗟𝗶𝗴𝗵𝘁𝘀 - 𝗨𝗽 𝗧𝗼 𝟱𝟱% 𝗪𝗮𝗶𝘁𝗶𝗻𝗴 𝗙𝗼𝗿 𝗬𝗼𝘂! 👉 www.excelforfreelancers.com/XmasSale2024_YTPinnedComm

[@tadiwazanza1352]

Just wanna take this opportunity to extend my gratitude to you, Randy. I knew nothing about Excel and once i found you, i have improved significantly. Keep up the good work! Thank you so much!!!!

[@ExcelForFreelancers]

Thanks so much. Very kind of you and I am really glad that i can help and share, and thanks for your continued support

[@khadimhussainmomin1315]

Hi I m Momin from India. Thanks for all your videos. Wish multi user application. But in excel it’s not possible so kindly guide us

[@ExcelForFreelancers]

Hi @khadimhussainmomin1315 To share and sync your macro-enabled Excel workbook, please watch this training: kzbin.info/www/bejne/nJCUeaaIbphja6s

[@carloscrespo-riera9815]

Randy, I just want to thank you for taking the time sharing your knowledge and skills with all of us.

[@ExcelForFreelancers]

For sure, you are very welcome Carlos, and thanks so much for your comments and continued support. I really appreciate it

[@ExcelForFreelancers]

⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack

[@nerenlakhraj5252]

Thank you Randy, this refresher course is very enlightening 😊

[@ExcelForFreelancers]

For sure, you are very welcome Neren. I am happy that I can bring it to you

[@Template-analysis]

Im Vietnamese , This is great seri for beginner! Big thanks for your effort.

[@ExcelForFreelancers]

Xin Chao. For sure, you are very welcome . Cam on ban (I have lived in Vietnam for 8 years now. Beautiful Country)

[@nathanielaboagye2259]

Indeed grateful, Randy

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@intakhabkhan9649]

Thank you so much for informative and valuable video, it is very easy to understand by your lecture. Please keep it up continue.

[@ExcelForFreelancers]

For sure, you are very welcome and thanks so much. I am happy to help and share

[@jtwtube]

Thank you soo much !!

[@ExcelForFreelancers]

For sure, you are very welcome and happy to help and share

[@henkvinck888]

Thanks again Randy for your great explanation and video

[@ExcelForFreelancers]

For sure, you are very welcome Henk. I know these trainings may be a bit basic for you but I really appreciate your continued support

[@henkvinck888]

@@ExcelForFreelancers However, there is 1 question I have. How do I keep a good overview of the VBA section when you have created a lot of macros and how do I keep it well organized. And regarding the beginning of these lessons. It is important to experience it from the Master himself and you learn all the time. Thank you

[@ExcelForFreelancers]

Hi and thanks I have created a playlist for all the Basic VBA trainings here kzbin.info/aero/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z

[@SyedMuzammilMahasanShahi]

Thank you so much Randy for this amazing video.

[@ExcelForFreelancers]

For sure, you are very welcome Syed. I am glad you like the training.

[@laminulams8723]

Thanks a lot. You have been doing so much for us

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that and I am happy to help and share

[@Michael-Hubbard]

Thanks Randy, another great teaching. I actually thought the mentorship program was going to be like this and work our way up to making programs with what we learned, I'll work on the mentorship program more once I get better at VBA.

[@ExcelForFreelancers]

Hi Michael, that sounds like a good plan. The 132 hour mentorship program would probably well over 200 hours if I was going to includes the basic VBA training, so these beginner VBA Basic lessons should help You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared I hope this helps and thanks so much.

[@Sebastien_Frederic]

Amazing video as always Sir !

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Sebastien. Thanks for your continued support over the years.

[@waleedalisaeed2671]

سيد راندي يقال ان الكنوز توجد في الاوحال وانت كنز في اوحال القنوات المنتشرة على اليوتيوب.

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Waleed. Very kind of you

[@johnjacobjinglehimerschmid3555]

One of the best things I ever did while programming VBA, and I didn't do it long before getting laid off, was to use AutoHotKey to program to automatically put in the basics of for/next, do, select statements. I could type fornext and pooof it would transform into the perfect for next loop. I also did a forrng which would prompt me to activate the worksheet and select the top of the range and it would automatically format a dynamic range for the fornext loop.

[@ExcelForFreelancers]

oh wow that is a great idea. To be honest, I have not even used the AutoHotkey potential. It can do so much more than the way I am using it. It can literally automate almost everything, not just typing. I have to take some time to explore more of its power. Thanks again for sharing

[@nathanielaboagye2259]

@@ExcelForFreelancers so humble Randy. Keep it up

[@hayden6489]

Awesome stuff, as usual. Thanks so much!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Hayden and glad I can help and share

[@vinodrajeshkumar6025]

Thank you very much 🙏🏽🙂

[@ExcelForFreelancers]

For sure, you are very welcome and I am happy to help and share

[@j.fabricioelias227]

Great video. Thank you!

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that

[@JKGARMENT-z1w]

Hey Randy... Kindly make some video on accounting software using vba user form

[@ExcelForFreelancers]

Hi and thanks so much. I will do my best to get that done in the near future. I have a training with accounting and a userform coming up next week with a Tree View control. I hope this helps and thanks so much.

[@ezellmartin3141]

Very informative

[@ExcelForFreelancers]

Thank you for the kind words! I really appreciate your support and I'm glad you found the video helpful.

[@gerardvaneggermond2067]

Hello, I have a problem, I have a sum in C3, now I want to copy it to the next column and then add a cell to the next column up to column DW, what is the best way to do this, can you give an example, thank you

[@ExcelForFreelancers]

Hi and thanks you can link to the cell using an absolute reference such as =$C$3 then use a relative reference for the remaining cells. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

[@conan7422]

The most important thing has been forgotten: At "for", the loop starts with the first value, but it changes with the "next" statement, as long as the value is between min and max, the loop is repeated with the new value. It is therefore possible that a loop never ends if, for example, the loop variable is changed within the loop. Also: the value after exiting the loop with "next" will be outside of the last value: with "for a=5 to 7 step 2", for example, will be end with 9 and not with 7 after next!

[@ExcelForFreelancers]

Thanks so much for sharing. No doubt. Thank you for your Likes, Shares & Comments. It really helps.

[@kalpanathakur6300]

Sir in 2nd example why did you take Range as a type of variable and what is works and After that why did you write "For Each Cell " what is mean

[@ExcelForFreelancers]

Hi and thanks the Range will allow us to loop through specific cells within a range and the "For Each Cell" allows the macro to check each cell in the range. I hope this helps and thanks so much.

[@AyushmanThakur-mo3ee]

@@ExcelForFreelancers But in place of "For Each Cell" we can Specify the range also suppose A1:D10 then also it will go to the each cell i am getting confusion in this Thank you....

[@ExcelForFreelancers]

Hi and thanks for your feedback. I know it can be a bit complex and I will create additional videos in the near future to make that clear. I hope this helps and thanks so much.

[@kalpanathakur6300]

​@@ExcelForFreelancers Thank you so much sir ☺️