Hi, thans a lot for your videos they are helping me a lot. I would like to ask abouy a doubt i have. Which aproach it is faster, a for loop or autofill? I handle with large data with 100.000 rows so the theme faster is important. And one more time, thanks a lot for your work.
Hi, in the section "How the For Loop works" you have to define the worksheet that "shNumbers" is. My code was breaking until I figured I had define which worksheet would be "shNumbers". Hope this helps someone in the future.
Actually, using i as the loop counter is a holdover from Fortran. In Fortran, what letter a variable name begins with implicitly determines what type of number it is. Loop counters need to be an integer type. The letters i thru n were automatically integers in Fortran so the counter in a Fortran Do loop began with i,j,k,l,m or n. Most coders used them in alphabetical order so i = 1 occurred most often and it became a convention to start loops in Fortran with i. [The Do loop in Fortran is the equivalent of the For loop in VBA]
very clear, im trying to simulate time and have cells coloured in real time from milliseconds to seconds, each with differing intervals depending on user input, does VBA have built in time functions
Hi, thank you, that was really great and professional, I have a problem though. am writing a code with (for) (for r = 27 to 32) and I already added if isempty function. but it's always taking the whole range and not stopping on empty cells. even though that same code worked on other application but not this one. is their any reason?? Hint: my data is not in separate sheet, in the same sheet I have other data, would that affect? I will very much appreciate if you can solve this problem for me. thank you.
Hi Paul. Awesome lesson, as always! Nice to refresh these concepts and reinforce them in memory with practice and examples. Thanks for sharing :)) Thumbs up!!
Vba is an excellent subject then why Microsoft company not encouraging such a nice language.. Plz advice. I will miss vba in my future.. It's eazy as far as what I knew
Do you realize how much money people can make with the right background using these skills? SCADA uses these principals all the time. Especially in the oil and gas industry. I am just barely scratching the surface of VBA in excel and I have already changed the company.
hi Sir, I am stuck somehwere in excel. I hope you can help me. I am generating a random number using vba command (randbetwee,1,6)...and i want to add the result each time when i clcik the button.. on click 1: random number 5, Store the value 5 on click 2: random number 2, store the value 7 on click 3: random number 1, store the value 8..and so on...can you please help me..many thanks in advnace.
Hello sir, maybe you can help me, I made a code but it is too long now I want to reduce it, is this possible? One section has the following code; Application.ScreenUpdating = False If Sheets("Menu").Range("E2") = 1 Then Sheets("toplay1").Select Range("A1").Select5 ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[1]:R[20]C[1],'S1'!R[1]C[1]:R[20]C[1]" "")" Range("B1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[5]:R[20]C[5],'S1'!R[1]C[5]:R[20]C[5]" "")" This continues, at (c[ ]) each time 4 is added until 37 is reached Could you help me? Thanks in advance. d
Let me know what you think about For Loops in the comments.
Make sure to download the source code with 20+ For Loop Examples from the description.
Hi I wana to say ur for loop class was very amazing bcz your teaching way is very unique.. nd clear so m loving it tq 👍🏻👍🏻👍🏻
I can't download the source code with 20+ For Loop examples, The link takes me to download a PDF file named "VBA Vitals cheat sheet".
Thanks.
I'm starting with VBA... It's very useful to know how manage a For Next loop... Thanks!
I wish I had such teacher at the beginning. Professional video.
Anyway, I'm a fan, like to listen to You smoothly explaining those things.
Thank you, your description is very clear and easy to understand.
I did not know For Each ran faster than For i. I always used For i because I could use the i within the loop. Thank you for the guide, very thorough.
Hi, thans a lot for your videos they are helping me a lot. I would like to ask abouy a doubt i have. Which aproach it is faster, a for loop or autofill? I handle with large data with 100.000 rows so the theme faster is important. And one more time, thanks a lot for your work.
Hi, in the section "How the For Loop works" you have to define the worksheet that "shNumbers" is. My code was breaking until I figured I had define which worksheet would be "shNumbers". Hope this helps someone in the future.
For looping through ranges, I like the additional Dim cell as Range method where it's for each cell in rg, next cell, etc.
The upside is that it's neater to write. The downside is that it's not flexible if you need a different order or just some of the cells.
Actually, using i as the loop counter is a holdover from Fortran. In Fortran, what letter a variable name begins with implicitly determines what type of number it is. Loop counters need to be an integer type. The letters i thru n were automatically integers in Fortran so the counter in a Fortran Do loop began with i,j,k,l,m or n. Most coders used them in alphabetical order so i = 1 occurred most often and it became a convention to start loops in Fortran with i. [The Do loop in Fortran is the equivalent of the For loop in VBA]
Please continue posting this kind of guides!
Lbound for the low variable in array loops... I always learn something. Thank you for the lesson.
Glad you like it Tom
Brilliant - Crisp and to the point , thanks a lot Sir
Been followed you channel for awhile, do you have a recommended list to properly start from beginning level from your video?
Very nice! Just be aware that arrays can be zero based as well. Your I would then need to start at 0.
very clear, im trying to simulate time and have cells coloured in real time from milliseconds to seconds, each with differing intervals depending on user input, does VBA have built in time functions
Very very intersting class, thank you so much sir.
Nice video, would you mind teach me more?
Why "For i = 1 to 3" is 3 times looping only, but the final i is 4?
I don't understand the logic here.
great stuff.
You stated:
Make sure to download the source code with 20+ For Loop Examples from the description
where are they please?
Beside "Download the Source Code"
@@Excelmacromastery , No, the Link take you to download a PDF file "VBA Vitals Cheat sheet"
Very useful nd very clear your teaching way tq sir 👍🏻👍🏻👍🏻👍🏻
Thanks Vijay
Hi, thank you, that was really great and professional, I have a problem though. am writing a code with (for) (for r = 27 to 32) and I already added if isempty function. but it's always taking the whole range and not stopping on empty cells. even though that same code worked on other application but not this one. is their any reason?? Hint: my data is not in separate sheet, in the same sheet I have other data, would that affect? I will very much appreciate if you can solve this problem for me. thank you.
Great tutorial as always Paul 👌 clear and to the point, must say it's been a long time coming
I think if I used arrays, lbound and ubound more often, my code would be easier lol. Need to start using them more often 👍 Great video
Thankyou for the facile explanation.
Thank you so much Paul.
Hi Paul. Awesome lesson, as always! Nice to refresh these concepts and reinforce them in memory with practice and examples. Thanks for sharing :)) Thumbs up!!
Is it possible to give the sheetname, ranges, copy, destination sheet, destination range,and using lopping copy and paste based on the inputs given
Excellent...well explained...thanks for this video...
Sir, Very nice and well explained. Thanks a lot .....
Nice, as always!👍👍👍
Thanks John.
Hey paul, how can you enter a new line if a condition is met?
Vba is an excellent subject then why Microsoft company not encouraging such a nice language.. Plz advice. I will miss vba in my future.. It's eazy as far as what I knew
Great work!
Hi, In your Number Input box example, I want to use a cell value instead of user value how to do that... Plz help me out
Great video! Thanks
You're welcome!
Hi, how to make a loop in criteria of an autofilter in a column
Hi sir, please make a video on Userform.
Thank you
Good one, thank you, Cheers
Glad you enjoyed it
Nice sir 👍🏻👍🏻👍🏻👍🏻
Please, which is this very nice mono font? Consolas?
Yes
i love you paul from INDIA
HI master, I'm from Santiago Chile, how can a buy your TheExcelVBAHandbook in equal parts? I can buy pdf1 in 40usd and so on?
Hi Alexis,
It can only be bought as one single course.
@@Excelmacromastery ok.
Thank ya
Very nice video
Thanks
Masterpiece!
When i write formula in vba , and when argument need write number, i make loop to sign number,,,, but code not working?? Why
Do you realize how much money people can make with the right background using these skills? SCADA uses these principals all the time. Especially in the oil and gas industry. I am just barely scratching the surface of VBA in excel and I have already changed the company.
hi Sir, I am stuck somehwere in excel. I hope you can help me.
I am generating a random number using vba command (randbetwee,1,6)...and i want to add the result each time when i clcik the button..
on click 1: random number 5, Store the value 5
on click 2: random number 2, store the value 7
on click 3: random number 1, store the value 8..and so on...can you please help me..many thanks in advnace.
I thunk in the first example of nested loop you wanted to use... Cells(i, j).. Instead of Cells(i, 1)..
Yes, I was focusing on the i and j values. Cell should be i,j for the nested loop.
I have no idea what you're talking about.
Hello sir, maybe you can help me, I made a code but it is too long now I want to reduce it, is this possible? One section has the following code;
Application.ScreenUpdating = False
If Sheets("Menu").Range("E2") = 1 Then
Sheets("toplay1").Select
Range("A1").Select5
ActiveCell.Formula2R1C1 = _
"=FILTER('S1'!R[1]C[1]:R[20]C[1],'S1'!R[1]C[1]:R[20]C[1]" "")"
Range("B1").Select
ActiveCell.Formula2R1C1 = _
"=FILTER('S1'!R[1]C[5]:R[20]C[5],'S1'!R[1]C[5]:R[20]C[5]" "")"
This continues, at (c[ ]) each time 4 is added until 37 is reached
Could you help me?
Thanks in advance.
d