boss!, i've been struggling with te syntax of a dynamic step, so say i want the loop to naturally step the row i'm currently on based on a condition, you have any tips on how i'd go about that? thx for the awesome content hope to soon enroll on the the mentorship
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!!!!
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.
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
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.
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.
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.
@@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
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!
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
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
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.
@@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....
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.
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
boss!, i've been struggling with te syntax of a dynamic step, so say i want the loop to naturally step the row i'm currently on based on a condition, you have any tips on how i'd go about that? thx for the awesome content hope to soon enroll on the the mentorship
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!!!!
Thanks so much. Very kind of you and I am really glad that i can help and share, and thanks for your continued support
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
Hi
@khadimhussainmomin1315 To share and sync your macro-enabled Excel workbook, please watch this training: ua-cam.com/video/f_1HsR9305I/v-deo.html
سيد راندي يقال ان الكنوز توجد في الاوحال وانت كنز في اوحال القنوات المنتشرة على اليوتيوب.
Thank you so very much, I really appreciate that Waleed. Very kind of you
Randy, I just want to thank you for taking the time sharing your knowledge and skills with all of us.
For sure, you are very welcome Carlos, and thanks so much for your comments and continued support. I really appreciate it
Great video. Thank you!
Thank you so very much, I really appreciate that
Im Vietnamese , This is great seri for beginner! Big thanks for your effort.
Xin Chao. For sure, you are very welcome . Cam on ban (I have lived in Vietnam for 8 years now. Beautiful Country)
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.
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
@@ExcelForFreelancers so humble Randy. Keep it up
Thank you Randy, this refresher course is very enlightening 😊
For sure, you are very welcome Neren. I am happy that I can bring it to you
Hey Randy... Kindly make some video on accounting software using vba user form
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.
Thank you so much for informative and valuable video, it is very easy to understand by your lecture. Please keep it up continue.
For sure, you are very welcome and thanks so much. I am happy to help and share
Thank you soo much !!
For sure, you are very welcome and happy to help and share
Indeed grateful, Randy
Thank you so very much, I really appreciate that
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.
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.
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. I am glad you like the training.
Thanks a lot. You have been doing so much for us
Thank you so very much, I really appreciate that and I am happy to help and share
Thanks again Randy for your great explanation and video
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
@@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
Hi and thanks I have created a playlist for all the Basic VBA trainings here ua-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
Amazing video as always Sir !
Thank you so very much, I really appreciate that Sebastien. Thanks for your continued support over the years.
Awesome stuff, as usual. Thanks so much!
Thank you so very much, I really appreciate that Hayden and glad I can help and share
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!
Thanks so much for sharing. No doubt. Thank you for your Likes, Shares & Comments. It really helps.
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
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
Thank you very much 🙏🏽🙂
For sure, you are very welcome and I am happy to help and share
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
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.
@@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....
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.
@@ExcelForFreelancers Thank you so much sir ☺️
Very informative
Thank you for the kind words! I really appreciate your support and I'm glad you found the video helpful.