Brilliant! I've been (casually) coding VBA in Excel for >20 years and I didn't know some of these! Doh! Please keep doing "Another 5" videos until you run out of ideas. :) Thank you!
@Excelmacromastery
5 жыл бұрын
That's really good to hear Chris. I think I'll be able to come up with another few useful tricks.
@ThorstenStrauch
5 жыл бұрын
The same is valid for me. Just one word: Whow!
@muhammedwafa9646
5 жыл бұрын
Please advise, I have a problem with my Excel sheets it has equations and simple codes to navigate between the sheets . But I have to work on 4 or may be 6 sheets at the same time. But Excel tends to crash every time and shows the message"Excel has stopped working " as soon as I got the enable macro button. Thank you
@jacksonmacd
5 жыл бұрын
Save here!
@Husky_Passion
4 жыл бұрын
for real ? lol, took me 3 months on self learning to know that
@PJTarver
2 жыл бұрын
This guy is the best out there by far. For anyone trying to learn VBA for Excel, start here.
@elijahkehayias6531
8 ай бұрын
I have watched many, MANY! KZitem Videos in order to improve and learn VBA. You are by far the BEST. Explaining the Fundamentals is what teaching is all about, not just "tricks". I am definitely signing Up for your Course. Excel not an easy topic to learn and not every-one has the ability to teach. Thanks for your VIDS. HUGE THUMBS UP.
@Excelmacromastery
5 жыл бұрын
Hi everyone, I hope you will enjoy these useful things that I wish I knew when I started using Excel VBA. Please add any comment or queries below the video. Thanks all.
@MohammedImranH
5 жыл бұрын
Hi.. Which video editor, screen recorder do you use and audio recorder as well?
@s.m565
4 жыл бұрын
Thanks Paul, great stuff.
@gregbernard7861
Жыл бұрын
I have been an intermediate VBE coder for years (do not want to be advanced) - but your channel is great.
@missile-shapedbourbon4060
5 жыл бұрын
Just knowing that people can't break the macro by renaming the sheet is a dream! Thank you so much!
@Excelmacromastery
5 жыл бұрын
You're welcome:-)
@Porconion
2 жыл бұрын
Many thanks. Especially the array part. I shed a tear. Happiness? The fact I wasted so much time in the past? It is just the powerfull simplicity at the end.
@MD.TOUFIKULALAM
11 ай бұрын
Assalamualaikum sir i am toufikul alam from dhaka bangladesh. Brilliant idea. i am fan of you vba tutorials. greet thanks
@redmicrouser7954
2 жыл бұрын
I love your calm pleasant speaking style. Bonus is succinct, well organized steps of instruction. I give an A+ to this Instructor.
@Excelmacromastery
2 жыл бұрын
Thanks😀
@simonbrowning5423
5 жыл бұрын
At least 15 years of struggling with Arrays, Range limits and parsing text. I wish I’d known these too. You have one new sub. Thank you.
@Excelmacromastery
5 жыл бұрын
Great to have you on board Simon.
@houstonsam6163
5 жыл бұрын
Many thanks for such clear, well-organized, and focused content. I'm the "Excel guy" in my workplace; there are a few KZitem experts I rely on for effective tutoring to increase my knowledge. You're my KZitem subscription for VBA.
@Excelmacromastery
5 жыл бұрын
That's great to hear Sam. I'll be adding lots more content.
@candeffect
5 жыл бұрын
'Codename' cleans up the code. Excellent! Subscribed.
@Excelmacromastery
5 жыл бұрын
Glad you like it.
@misterhorse8327
Жыл бұрын
Oh wow... Code Names just blew my mind right now.
@prakashsrinivasan7840
2 жыл бұрын
Omg that codename is very useful thanks. Of course everything in excellent keep on videos like this
@grtraders
5 жыл бұрын
Paul, I rarely comment on any of the youtube videos and just move on most of the time. However, I just wished to make an exception here. I just wish to say that by far you are one of the most brilliant tutors on the internet (that I have come around) in the excel vba arena. Please keep up the good work. It is a pleasure to watch your informative videos. Thanks, Ravi.
@Excelmacromastery
5 жыл бұрын
Thanks so much Ravi. That is very high praise indeed.
@marshallhosel1247
2 жыл бұрын
Thank you for this straight forward tutorial.
@adamwstbrook
4 жыл бұрын
The array portion was amazing! I didn't know it could use it like that. Definitely a game changer for me.
@tuworlds
Жыл бұрын
i'm late but still wanted to say thank you for these tips. each and everyone of them is pure gem
@warrenhall1750
3 жыл бұрын
Paul, Taking a step back to see the fundamentals is an interest tour. I wish I had taken that step almost two decades ago. VERY well done. Thanks. Always a pleasure to "see" you.
@Excelmacromastery
3 жыл бұрын
Thanks Warren. Glad you like it.
@byronquelal1647
4 жыл бұрын
your channel is awesome! your code is very clean and elegant!
@Excelmacromastery
4 жыл бұрын
Thanks Byron
@Patrick-ge2zn
4 жыл бұрын
Many thanks, with arthritic fingers the less typing I do the easier it is for me . This site is a God send .Thanks again.
@michaelreese5085
5 жыл бұрын
I knew all of them, but the way you use the watch window is something I've never seen and now will use more frequently! Thanks!
@Excelmacromastery
5 жыл бұрын
Glad you like it Michael.
@JanBolhuis
5 жыл бұрын
Great video. Thanks. I'm on a mediocre level but codename was one of the 1st things I have learned from you. Now working on arrays.
@Excelmacromastery
5 жыл бұрын
Thanks for the feedback Jan.
@jamesart9
4 жыл бұрын
Wow, I have been using Excel professionally for 20 plus years and, damn, just learned 5 new things. How I managed without knowing this all these years astounds me. Thank you, thank you, thank you.
@mangobrother
4 жыл бұрын
Using VBA for 2 decades. I did not know any these. Thanks a lot mate. More please... Cheers.
@simonliang6867
4 жыл бұрын
The video is very useful for me.I learn a lot tickets,thanks.
@smithsmith8288
3 жыл бұрын
1st and 3rd one are easy and brilliant. i never knew that. it would be very helpful. thxs
@Paladin101
2 жыл бұрын
Literally started vba this month and found this priceless 🙂. As are your others, especially those relating to error handling.
@charlielorenzo3644
2 жыл бұрын
I still cannot figure it out where to start
@ragnarok7976
Жыл бұрын
@@charlielorenzo3644 Might I suggest playing around with the macro recorder. It will write the shittiest code possible but I found it nice to get a rough idea of what regular tasks in excel look like when you automate them. Plus it can be kinda fun to use too!
@SMEEST55
4 жыл бұрын
Your best video is that about using both arrays and dictionaries
@Excelmacromastery
4 жыл бұрын
Thanks Rik
@ivanonanga2195
5 жыл бұрын
Hi EMM, you cannot even imagine what you have done for me and my department... Thank you is not enough!
@Excelmacromastery
5 жыл бұрын
Thanks Ivan. You're very welcome.
@harnesshouse
3 жыл бұрын
Worksheet code name just solved a problem I was thinking about. Thanks!
@yannhk
4 жыл бұрын
Very helpful to improve my coding. This is brilliant.
@Excelmacromastery
4 жыл бұрын
Great to hear!
@ryanmattson1546
2 жыл бұрын
Great job. Great teacher!
@rrrprogram8667
5 жыл бұрын
This is the one of important lessons to take from experienced experts
@Excelmacromastery
5 жыл бұрын
Thanks glad you like it.
@terrycline8689
5 жыл бұрын
Hi Paul - I am new to this channel and wow, I am BLOWN away! I have written a zillion macros for work, and I completely confess I am amateur in the way I code. I do things very simply, mostly because I need to prove to myself that my loop or function or calculation a) captures and processes the records my logic says it should capture, and b) subsequent manipulation of that data is accurate. So, you can bet my code is bloated and often unnecessary. But it works. Once I am confident everything is working, i would LOVE to speed the code up, minimize where possible, and use all of the built in tools Excel VBA already provides. But I admit that I don't know them very well. Your channel - for me at least - provides the best, simplest, most complete explanations I think I have ever seen. I learned more about how to populate an array in one of your videos then I learned over the past 6+ years of tinkering with this stuff. THANK YOU! I hope you are able to keep it up. You have a fan in California!
@Excelmacromastery
5 жыл бұрын
Thanks very much for the feedback Terry. That is high praise indeed. I appreciate it.
@richch888
4 жыл бұрын
Paul, I know what you are doing takes a lot of effort to produce. Thanks so much! Your tips are invaluable.
@Excelmacromastery
4 жыл бұрын
Glad you like them!
@satyamjha7402
6 ай бұрын
Simple and brilliant.
@mariaalcala5159
3 жыл бұрын
Great Video! Thanks for sharing your knowledge!
@haiderbokhari1
5 жыл бұрын
What can I say, your videos are BRILLIANT! Please keep making more! I feel my weekends are so much more productive!!!
@Excelmacromastery
5 жыл бұрын
Thanks for your nice comment.
@haiderbokhari1
5 жыл бұрын
@@Excelmacromastery Thank YOU for sharing your knowledge!!
@excelmastervba
3 жыл бұрын
Hi, yes that would have been really great to know at the beginning already. Thanks a lot for sharing! 🙂
@Excelmacromastery
3 жыл бұрын
Glad it was helpful!
@excelmastervba
3 жыл бұрын
@@Excelmacromastery it was 👍🏻
@careywong8893
4 жыл бұрын
Thank you very much. It's really helpful.
@MrRandsauce
5 жыл бұрын
Like the range to array. Thanks a handy one.
@Excelmacromastery
5 жыл бұрын
Thanks Mark.
@skybadou
2 жыл бұрын
Nice, I knew 2 out of 3! Good video thx
@sharminfariha4911
5 жыл бұрын
The use of a variant array for copying range to an array and split function is very helpful. Thank you!!
@Excelmacromastery
5 жыл бұрын
You're welcome Sharmin.
@MichaelLass
5 жыл бұрын
I have been learning Excel VBA for several months now and what a mess I coded. I learned so much more in 30 minutes of your videos, that I will rewrite my code for a third time to be much cleaner and more efficient. Thanks
@Excelmacromastery
5 жыл бұрын
You're welcome Michael.
@ThePablete15
4 жыл бұрын
Muchas gracias por video! Estoy justo aprendiendo VBA y aprendiendo que los arrays hacen más eficiente mi código.
@eisayev
3 жыл бұрын
The first one was goooood 👍
@rods6405
4 жыл бұрын
Thanks been writing Excel macros and VBA since the 90s did not know the CurrentRegion property. You do have to burn a column to use it, not a big issue as you can just change the background colour of the first row of that border column. Can also get last row or column much nicer than other methods and also grab the data as an array Dim MyRange1 As Range: Set MyRange1 = Sheet6.Range("A1").CurrentRegion ' Get Last row and column Dim LastRow1 As Long: LastRow1 = MyRange1.Rows.count 'Get Array From Range Dim MyRows1 As Variant: MyRows1 = MyRange.Rows ' also works with MyColumns = MyRange.Columns
@venkyr81
3 жыл бұрын
Thanks all 5 were new information for me. Thanks for sharing your invaluable knowledge!!
@viola20353
4 жыл бұрын
Thank you for these brilliant information. Specially the codename for the sheet and the current region and the other tipps.
@Excelmacromastery
4 жыл бұрын
You're very welcome!
@tranyarelisher4185
5 жыл бұрын
I tend to use the sheet index but I am going to incorporate codename more now. You eliminated everything I hated with the array code... can't believe I have not seen that before...many thanks.
@Excelmacromastery
5 жыл бұрын
Glad to help
@blackinktraining9810
4 жыл бұрын
Great video Paul. I teach a VBA course at a Canadian university and we cover a lot of those techniques. Nice to see someone else setting everyone straight!
@Excelmacromastery
4 жыл бұрын
Glad you like them:-)
@PHILIPROYBENEDICTLOUIS
3 жыл бұрын
Thank you so much, this is life saver.
@ClaudioBOsorio
3 жыл бұрын
Wow this is great Thanks for teaching those cool tricks!
@Excelmacromastery
3 жыл бұрын
No problem!
@kevinpaul2742
9 ай бұрын
all tips are very usefull,thanks!
@ziggle314
5 жыл бұрын
First-rate exposition. I will use these tips regularly. Thanks.
@Excelmacromastery
5 жыл бұрын
You're welcome
@wisecatnoroboris
3 жыл бұрын
Thank you so much for this video!
@MichaelMadiganDublin
5 жыл бұрын
Thanks for the videos - super helpful and very well presented.
@Excelmacromastery
5 жыл бұрын
Thanks for the feedback Michael.
@mkparker99
2 жыл бұрын
Brilliant advice!
@felipelandim2881
4 жыл бұрын
Just awesome. Thank you.
@Anukiranvlogs
3 жыл бұрын
Awesome, great ideas. Thank you very much ☺
@camambara
4 жыл бұрын
Thanks for sharing, I've learnt with you how to copy range to array easily, it helped me out a lot
@ragnarok7976
Жыл бұрын
Very nice. I was literally trying to solve the "user changes sheet name" problem with out locking down the entire workbook and #1 fits the bill perfectly... Not to mention the rest of these tips are great too!
@eltonm.t.873
3 жыл бұрын
Very useful tips!
@wayneedmondson1065
5 жыл бұрын
Hi Paul.. thanks so much. These tips are GOLD!! Thanks to videos like this, your excellent web site and blog, and your paid course options, becoming good at VBA is available to anyone willing to put in the time. Thanks for sharing your knowledge and skills.. much appreciated and valued. Thumbs up!!
@Excelmacromastery
5 жыл бұрын
You're welcome Wayne. As always, thanks for the great feedback.
@DanBrill
4 жыл бұрын
Great stuff. One thing I wish I'd known earlier is that when making an array from a range, it will always be a 1-based array, not 0-based, even if you use Option Base 0 for the module. Thanks, Chris! I've learned a lot from you.
@Excelmacromastery
4 жыл бұрын
Who's Chris?😄
@DanBrill
4 жыл бұрын
@@Excelmacromastery Ha! Sorry, Paul. You can tell I'm new here.
@danwhiffen9235
5 жыл бұрын
Omg that code name is great. I’ve been modifying my code for years because I link to another excel spreadsheet and the owner of that is always changing the name of the tabs and thus breaking my code. I’ll try it out tomorrow. Thanks
@Excelmacromastery
5 жыл бұрын
You're welcome.
@srinivasraogampala4420
4 жыл бұрын
He is really a genius... His codes are short and fast!!
@julianevans2256
Жыл бұрын
I've been using (and learning) vba for many years and only recently learned about Debug Compile from this video, I used it (along with Option Explicit) on my Personal.xlsb workbook and it took me days to clean up the code! Great tutorials
@davidlee522
5 жыл бұрын
Your videos are so awesome, so well organized. Everyone can tell you put a lot of hard effort and making it so easy to follow and learn. You're amazing and raising the bar for everyone!
@Excelmacromastery
5 жыл бұрын
Thanks very much David. That is high praise indeed.
5 жыл бұрын
Thanks a lot. Your website is one of the best out there for excel vba. I just found that KZitem channel and immediately subscribed to it. Very useful videos.
@Excelmacromastery
5 жыл бұрын
Thanks for the feedback. Glad you like it.
@sandeepkothari5000
5 жыл бұрын
Paul, I too wish I knew these beforehand.
@Excelmacromastery
5 жыл бұрын
Thanks Sandeep. Glad you like them.
@oldhatman6769
4 жыл бұрын
Very good, very useful
@JANtheDane
5 жыл бұрын
Awesome advice! I was blown away by the simple Array code.
@Excelmacromastery
5 жыл бұрын
Thanks Jan. Most people are amazed when the see it first - myself included.
@wattjock
3 жыл бұрын
Just started teaching myself Excel VBA, for very specific reasons, and very much appreciate your sharing you experience here for novices like me to benefit from! Definitely Subscribing to your channel and will most probably be buying guides from your website in the very near future once I master your basic info!
@Excelmacromastery
3 жыл бұрын
Thanks Watt. Glad you liked it.
@Lutfitince
4 жыл бұрын
Very nice videos, and great shortcuts. You not only explain the theory of the functions but also explain solutions to real life situations, and while doing you always have in mind the code speed, as using macros is about speeding processes up in the first place. All is great, but it will be even better if the videos are more organised. Thank you very much for the great content and especially the tips that really matter, game changers when dealing with troublesome scenarios and the pro insights that enable us perspective when approaching problems. Just what people need to get to the next level. Thank you very much again!
@Excelmacromastery
4 жыл бұрын
Thanks for the feedback. Glad you like the videos.
@marcusnelson3520
5 жыл бұрын
Hi, you are a legend. Thank you so much!
@Excelmacromastery
5 жыл бұрын
Thanks for your comment Marcus.
@niavras
3 жыл бұрын
Great stuff! Thank you!
@Excelmacromastery
3 жыл бұрын
Glad it helped!
@lbarrera2197
5 жыл бұрын
Thanks! very good tutorial. Short, clear and concise.
@Excelmacromastery
5 жыл бұрын
glad you like it.
@versusstats7051
4 жыл бұрын
Very useful. Thanks.
@Mitology
4 жыл бұрын
Very good thank you!
@martyc5674
3 жыл бұрын
Excellent thanks a lot
@Agapeisthebest
3 жыл бұрын
Thanks for sharing.
@joaocustodio2094
5 жыл бұрын
As always, very useful and clear. Thanks Paul.
@Excelmacromastery
5 жыл бұрын
You're welcome João.
@reevesjim
4 жыл бұрын
Thanks from Norway! I just klicked the subscribe button, and will be checking out a lot of your videos!
@Excelmacromastery
4 жыл бұрын
Thanks Jim.
@jgenterprisesnew9552
5 жыл бұрын
GREAT x 3 !!! I really enjoined this video, specially the SPLIT trick. Back in the 80's I worked writing code for a company that did a lot of mailing. We would get a "dirty" list of names, and had to "clean it up" before we could use it for mailmerge with WORD. I don't know if SPLIT existed then but if it did I wish I've know about it.
@Excelmacromastery
5 жыл бұрын
Thanks. Yes, split is a great function - My next video will show examples of using split.
@houstonvanhoy7767
3 жыл бұрын
I suspect that VBA has a lot of built-in functions (like SPLIT, for example) that few VBA coders know about. If more people used VBA, perhaps that kind of knowledge would be more widespread than it is. But leave it to Sir Paul to dig it out, use it and explain it to us. Many thanks to the master!
@mercthedancechild
3 жыл бұрын
Nice video 👌
@afilipppp
5 жыл бұрын
so much time lost finding ranges... glad i clicked this suggested video. ty man
@td1138
4 жыл бұрын
Very helpful tips! Thanks so much.
@thebesttechnical3608
5 жыл бұрын
Very useful information nice video
@tgirard123
5 жыл бұрын
Holy crap, just what I needed. Subscribed. I've learned something new in every video.
@Excelmacromastery
5 жыл бұрын
Thanks Timmy. Glad you like it.
@fordfactor
5 жыл бұрын
Tip 1 I found a few years ago: makes things sooo much easier. I would add a related tip and that is to use Defined Names for cells: if you need to move the cells referred to in your code around on your sheet, the defined name goes with them and you don't have to change your code. Although you probably knew that already! :)
@seaalbahr2404
4 жыл бұрын
Wonderful .... Thanks
@vivekphadke16
5 жыл бұрын
That is very insightful and of a great help for a 'VBA novice' like me. Thanks a lot.
@Excelmacromastery
5 жыл бұрын
Thanks Vivek. Glad you like it.
@eicosano
5 жыл бұрын
I've been coding and this was very helpful in glad I stomped on your video thank you very much
@Excelmacromastery
5 жыл бұрын
You're welcome.
@maciejdolinski1036
5 жыл бұрын
Great video. As usual. It saved me a lot of time. Thank you, Paul.
@Excelmacromastery
5 жыл бұрын
Good to here Maciej
@rayhanrana6773
5 жыл бұрын
You ate just true genius.
@Excelmacromastery
5 жыл бұрын
Thanks Rayhan
@adamploof3528
5 жыл бұрын
Really glad to see some new VBA videos with such great instruction. I use VBA almost daily and find these tips really useful. Only feedback I have at the moment is that I wouldn't mind if the sounds of the mouse clicks were a lot quieter -- it's a little distracting. Please keep these coming!
Пікірлер: 472