Hi Andy, you are definitively the best VBA Teacher ever...To be a good Teacher means not just have huge knowledgees, but to be eable to transmit them and make it comprehensible for the listeners.... a big Thank
Andrew, you always make things better. Thank you for the complete explanation on NOT and implicit TRUE statements. I will be adding this video to my favorites for future reference.
your welcome @@WiseOwlTutorials if possible to have a video comparison of which loop is the fastest 1) do loop until 2) do until loop 3) for each loop 4) find and findnext enclosed to a do loop regardless of where until is placed let’s say test it for a certain number of rows like 10000 more or less I think that would be a great content Thanks in advance
Great tutorial Andrew as all of your previous tutorials. While I was ploughing though your VBA Introduction tutorials I was redirected from tutorial on Find function to this one due to the need to learn more on Is Nothing statement. It helped me a lot to understand more on Is Nothing statement within If for which I am really thankful.👍
This video triggered a memory that I can't corroborate, but when I was taught one of the older languages (Fortran?) it was something about using the Not operator because it processed faster in machine code.
That's True (no pun intended), when using If ... = 0, we are using identity check which is relatively expensive task. Especially so in comparison to NOT operator / function - - the only unary fn, mind you, it simply takes whatever and inverts it out back at ya. Can't beat that, it's like it don't care what has it get, you'll receive the "opposite", Boolean wise. But, nowadays this benefits are miniscule and insignificant.
@@WiseOwlTutorialsYou are welcome. And thank you for being so generous in sharing bits of your many expertises! Being the one of subscribers to this channel myself (I took effort to go through and through your excellent website as well), I just wanted to say that your selfless work is appreciated! There are materials here that cannot be found anywhere else on yt (not free of charge that is) and yet you don't rush explaining, you don't click bait and don't use weird background music.. I mean, I have a kind of "goldilocks phenomenon" with WOwl - kinda fits perfectly and I do like it very much.
Just to correct myself in previous comment, the NOT is the only unary *operator* obviously. (It could and do exist as a function too but that's different, a lot of competition there.)
Great video Senpai... I have been watching your videos since a very long time...i was afraid when you did not upload any video for about 1 year....i was worried about your health as you know this is a tough time for the entire world..now when i got the first notification i was so happy...love your videos...i have had shared your videos with my colleagues and friends.. recommend so many to watch and learn from the master of VBA
Thank you so much Atul for both your kind words and your concern. It has been a strange year for everyone and we had a lot happening behind the scenes which meant that the videos had to take a back seat for a while. I hope that you and your family are well and thank you for taking the time to write such a nice comment!
Hi Roland, I'm replying here to your comment about mobile emulation in Selenium because RUclips seems to have eaten your comment! I have the email notification but the comment itself has disappeared from RUclips. Anyway, I haven't done this myself but I've added your question to the list and I'll look into it when I can. I have lots of teaching this week so it might take some time!
Sir only one request. Please don't delete or remove any video. I have just started to learn VBA. You make VBA is so easy to learn.. please sir don't remove just a request
Please don't worry, we have never removed a video from the channel! Even the absolutely awful ones from nearly 10 years ago are still there somewhere! I hope you enjoy learning VBA, good luck!
@@TheSTEPHEN009 Hi there, you can see our Introduction to Excel VBA course schedule here www.wiseowl.co.uk/vba-macros/online/microsoft-excel-macros/ We're running courses online only at the moment but hope to be back to running classroom courses before the end of the year. I hope that helps!
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Hi Andy, you are definitively the best VBA Teacher ever...To be a good Teacher means not just have huge knowledgees, but to be eable to transmit them and make it comprehensible for the listeners.... a big Thank
Thank you so much for the kind comments!
Andrew, you always make things better. Thank you for the complete explanation on NOT and implicit TRUE statements. I will be adding this video to my favorites for future reference.
You're very welcome Kevin, happy to hear that you enjoyed it!
Love for the teaching style as always, love to watch over and over thanks Mr. Andrew🤝👍👍
Thank you Sim! Happy to hear that you enjoy the videos and thanks for the comment!
this channel is very good when it comes to coding vba I've learned a lot from them
Thank you Ed, happy to hear you've found the channel useful!
your welcome @@WiseOwlTutorials if possible to have a video comparison of which loop is the fastest
1) do loop until
2) do until loop
3) for each loop
4) find and findnext enclosed to a do loop
regardless of where until is placed
let’s say test it for a certain number of rows like 10000 more or less
I think that would be a great content
Thanks in advance
@@edtardaguila3599 Thanks for the suggestion Ed, I'll add it to the list!
Your way of explaining thing is beyond imagination. Amazing work as always.
Thanks so much!
Hi Andrew. Thanks for this lesson. Very well explained and useful to understand how the logic works. Always enjoy your videos :)) Thumbs up!!
Thanks Wayne, appreciate the support as always!
Absolutely perfect way of explaining VBA coding. Thank you very much sir!
I'm happy that you think so! Thank you for the comment and for watching!
Great tutorial Andrew as all of your previous tutorials. While I was ploughing though your VBA Introduction tutorials I was redirected from tutorial on Find function to this one due to the need to learn more on Is Nothing statement. It helped me a lot to understand more on Is Nothing statement within If for which I am really thankful.👍
Thanks Denin, I'm happy to hear that this helped you! Thank you for watching and for taking the time to write a comment!
This video triggered a memory that I can't corroborate, but when I was taught one of the older languages (Fortran?) it was something about using the Not operator because it processed faster in machine code.
That's interesting, I didn't know that, thanks for sharing!
That's True (no pun intended), when using If ... = 0, we are using identity check which is relatively expensive task. Especially so in comparison to NOT operator / function - - the only unary fn, mind you, it simply takes whatever and inverts it out back at ya. Can't beat that, it's like it don't care what has it get, you'll receive the "opposite", Boolean wise. But, nowadays this benefits are miniscule and insignificant.
@@zstanojevic9574 Puns are very welcome here! And that's very interesting background information, thank you for taking the time to share it!
@@WiseOwlTutorialsYou are welcome. And thank you for being so generous in sharing bits of your many expertises! Being the one of subscribers to this channel myself (I took effort to go through and through your excellent website as well), I just wanted to say that your selfless work is appreciated! There are materials here that cannot be found anywhere else on yt (not free of charge that is) and yet you don't rush explaining, you don't click bait and don't use weird background music.. I mean, I have a kind of "goldilocks phenomenon" with WOwl - kinda fits perfectly and I do like it very much.
Just to correct myself in previous comment, the NOT is the only unary *operator* obviously. (It could and do exist as a function too but that's different, a lot of competition there.)
Very clearly explained. Thank you Andrew. ❤👍
Thank you as always for watching!
Great video Senpai... I have been watching your videos since a very long time...i was afraid when you did not upload any video for about 1 year....i was worried about your health as you know this is a tough time for the entire world..now when i got the first notification i was so happy...love your videos...i have had shared your videos with my colleagues and friends.. recommend so many to watch and learn from the master of VBA
Thank you so much Atul for both your kind words and your concern. It has been a strange year for everyone and we had a lot happening behind the scenes which meant that the videos had to take a back seat for a while. I hope that you and your family are well and thank you for taking the time to write such a nice comment!
This is a fantastic video!
Thanks!
What a great content! And you're a great tracher as well
Thank you so much!
Very informative.Thank you.
Thank you Rohith!
Great contents and presentation as always.
Thank you Roland!
Hi Roland, I'm replying here to your comment about mobile emulation in Selenium because RUclips seems to have eaten your comment! I have the email notification but the comment itself has disappeared from RUclips. Anyway, I haven't done this myself but I've added your question to the list and I'll look into it when I can. I have lots of teaching this week so it might take some time!
@@WiseOwlTutorials Odd. I don't recall removing it. Maybe I'm getting old. Thank you for putting it on the "question list".
@@rolandtobiasz I think it's a RUclips problem, I've lost some questions from other users recently. I'll see if I can find out what's happening.
Sir only one request. Please don't delete or remove any video. I have just started to learn VBA. You make VBA is so easy to learn.. please sir don't remove just a request
Please don't worry, we have never removed a video from the channel! Even the absolutely awful ones from nearly 10 years ago are still there somewhere! I hope you enjoy learning VBA, good luck!
@@WiseOwlTutorials Thanks a million Sir.
@@WiseOwlTutorials sir how do I get in touch with you so that I can get a full VBA course from you. Paid course..
@@TheSTEPHEN009 Hi there, you can see our Introduction to Excel VBA course schedule here www.wiseowl.co.uk/vba-macros/online/microsoft-excel-macros/ We're running courses online only at the moment but hope to be back to running classroom courses before the end of the year.
I hope that helps!
@@WiseOwlTutorials ok Sir. I am going through it.. many thanks
Thank you very much.
You are very welcome as always, thank you for your continued support!
I like the way of writing "if not is nothing..." and I always do this way, BUT, no other colleague can follow this idea...
I can understand why, it isn't a very natural way of speaking! As with all things, practice makes perfect. Thank you for the comment and for watching!