How to Solve a VBA Error in Less Than a Minute

[@querrythis]

Debugging has given me some serious headaches. I cannot thank you enough for your explicit breakdown. Your tutorials have been an education for me.

[@mcallister7593]

I've been working with VBA for over a year, and every time I watch one of your videos I learn something new and invaluable that I wished I had learned long ago. They're all so clear and concise, and aimed at real every-day problems.

[@Excelmacromastery]

Thanks. That's great to hear.

[@JohnOvens]

Paul, I have not used the watches window much at all, but after viewing this online seminar I am a converted fan and now will be using it a lot more. I cannot thank you enough for the excellent training I have received from you over the years and in particular your VBA course, which is awesome.

[@Excelmacromastery]

Thanks a lot John, Glad you like it.

[@MagicOfMushrooms]

I had never seen the 'Break on all errors' That is extremely helpful! I've literally been commenting out my "on error goto ..." putting in "on error goto 0" temporarily and then having to change back later; and of course that applies to anywhere where I have error handling, so there could be multiple error handling sections... Checking a box is so much simpler 😄

[@donstruble7489]

Great job as always. Rather than bringing up the Watch window, you can get the value of any single variable by simply holding the cursor over the variable in the debug window. The watch window is then helpful if you need assistance finding or confirming the source of the data in that variable. I find if I am dealing with my own code the source is usually readily apparent and the watch window is not needed. When debugging someone else's code or my own code that I have not seen in awhile the watch window is used more often.

[@Excelmacromastery]

Thanks for the feedback Don.

[@PROBeirne]

Well structured walkthrough, especially of Break on All Errors and editing the Watch Window.

[@Excelmacromastery]

Thanks Patrick

[@tophercahill8111]

Outstanding! This video is one of your very best Paul. I have struggled to use the Watch window effectively until now. Thank you & Well done!

[@Excelmacromastery]

Thanks Topher, Glad you found it helpful.

[@mateuszbajko4342]

I really appreciate you explain everything in the simpliest way there is. There are lots of VBA tips on the internet, but only a little of it is understable. Please do more of your best - as always :)

[@Excelmacromastery]

Glad to help!

[@gregnorthover5400]

every now and then if you are lucky you come across a gold nugget. This is one of those, I have used the watch window but can now see how much more useful it can be used...awesome tutorial.

[@Excelmacromastery]

Glad you like it Greg

[@scottgaines2677]

Another great job Paul! It didn't solve my problem, but I learned a ton and am on my way! Thanks so much!

[@srider33]

King of error trapping!! Another good video.

[@kishorekizz8446]

Excellent, perfect way to debug. I sometimes use immediate window, if it is complex, watch window is ideal choice. Thanks for your efforts on making this content.

[@Excelmacromastery]

You're welcome!

[@johnwayne8059]

As watching every of your videos, I could enjoy it truly much! Thanks for your informative and easy tricks about error handling and reverse engineering light! Hope publishing your next video won't need so much times! I hope your fine and thank you!

[@Excelmacromastery]

You're very welcome!

[@grzegorz2852]

man, you're just incredible. i have learned a lot from you. great content, simply to figure it out. great examples, etc. i have done a lot of different tutorials but your is the best. your blog is super helpful. owing to you, I have understood: arrays, collections. big thanks from Poland

[@Excelmacromastery]

You're welcome😀

[@TPPembabulous]

Nicely described!

[@gabrielvalmo5227]

Estoy aprendiendo bastante con tus videos gracias por compartir tus conocimientos.

[@Excelmacromastery]

You're welcome.

[@thesiantjabb]

You saved my life. Thank!

[@abdulhaseeb8027]

Great video and amazing way of explanation. It can come very handy

[@tuworlds]

thank you for this.... i know it will save me a lot of time

[@AnilKumar-vi8oe]

Fantastic as always, you are doing a great job

[@Excelmacromastery]

Thank you very much!

[@renaldomoon3097]

ty, i actually solved my problem in under one min. gj brother

[@TheUnicleo]

now I know how to use Watches window better. 🙏Can you please put some of your fantastic complete guide on text file handling in VBA?! I appreciate that.

[@Excelmacromastery]

I cover Text File Handing in my Excel VBA Handbook Course.

[@umeshlangade9231]

Thanks for quick tips

[@aeduardorp]

Very clear explanation, thanks

[@Excelmacromastery]

Glad you liked it

[@AaronBStephens]

Great tips, and great presentation.

[@Excelmacromastery]

Thanks Aaron.

[@hkoranteng1]

Great explanation!

[@Excelmacromastery]

Thanks!

[@hkoranteng1]

@@Excelmacromastery Had i have known you'd reply I would have elaborated a bit more lol! To put my comment into context, for me error handling is the most intimidating part of learning to code in VBA (or in any language for that matter). Your video broke it down so well that I literally have no idea what I was scared of in the first place. I can't recommend your videos enough. Keep up the good work.

[@warrenhall1750]

Another wonderfully presented Excel VBA explanation... as we have come to expect. Many thanks.

[@vbaclasses3553]

Excellent, as always. Thanks for sharing.

[@Excelmacromastery]

Thanks again!

[@chandrasekharswamypydikond5364]

Thank you. Helped alot❤

[@selenagomiz4086]

Hi do you know what causes "unexpected error (35005)" excel? thanks so much

[@GopiNath-fp5ly]

Excellent and very useful, thank you.

[@Excelmacromastery]

Glad it was helpful!

[@muhannad_youssef]

Please can we make record for errors by name of the macro and line number ( sometimes the employed don't have Permission to access VBA )

[@grahamparker7729]

Great tip 👍🏻

[@Excelmacromastery]

Glad it was helpful!

[@mikefinn7263]

I Need some help, I built a trim sheet that has around 25 Worksheets in the workbook. I built in a auto reset clear page button for each page about the pages work just fine with the pages protected or unprotected. The other half for some reason will rest just fine unprotected, but when I protect the sheet and hit reset I get and error code 400, How can I fix this?

[@SoulMateKsa]

Great job

[@karnabudhathoki5311]

Thanks very much for the information.....

[@Excelmacromastery]

My pleasure

[@wulp1191]

Nice one

[@muhammadsuleman6179]

Hi i hope you are fine and good. i have question? kindly reply I have VBA Macro excel file. it have a button in it. when i press the button it automatically get data from website and put it excel sheet with date. but unfortunately the file is not working now. when i run the file in other laptop it works fine. can you solve the problem to run the file in first computer?

[@nimrodzik1]

Thak You very much. Great as usual

[@Excelmacromastery]

Thanks again!

[@kishi3987]

Great content! Thank you for sharing your knowledge! My team has quite a few macros. Most of them open log files, read data, validates and extracts data on log files based on the position in the row. Then finally generats ouput files (log file) with the information based on the matched criteria. Most of the times because of extra spaces or characters macro not able to read data on source files (log files) and providing error messages. Could you please upload a video with log files and how to identify source file and the line of souce file where the error coming from? Thank you in advance!

[@kartickchakraborty9135]

Merry Christmas to you and your family...

[@Excelmacromastery]

Thanks Kartick. Best wishes to you and yours.

[@hericklenin]

Fantastic, thanks Sir.

[@Excelmacromastery]

Most welcome!

[@Chat2Conaz]

Just curious why you didn't mention the locals window?

[@rahulshewale9206]

Thank you sir

[@Temniknn]

Very usrfull

[@xenzomi1321]

Thank you so much!

[@Excelmacromastery]

You're welcome!

[@AI-ec2qb]

I bought your book 41 habits

[@bryanogden1419]

Thank You

[@Excelmacromastery]

You're welcome

[@wilholland100]

Thanks for info, however, my excel vba says out of memory and this is the code, literally, " Sheets("Customer").Select Exit Sub . . . ? This is an excel that was downloaded onto a brand new pc, and my old pc is where this file came from (works fine there, and that pc is pretty much out of memory). I'm hoping that there is a way way way easier answer- like a button that I just have to click. . . .This is almost no code. . . it is only "selecting a sheet"

[@Excelmacromastery]

Sounds like your code is in an event. When you select the sheet it triggers the event again and again until you have run out of memory. Turn off events at the start of the sub: Application.EnableEvents = False. Turn back on at the end: Application.EnableEvents = True

[@kartickchakraborty9135]

Happy New Year in advance to you Sir and your Family. May this new year bring all the happiness in your life. Sir I'm requesting you to please make videos on these topics given below. No one has ever discussed on these topics on internet in great details so that we can understand them properly. Please make videos on these 3 topics. By the way, I'm very much impressed with your teaching style. Your way of teaching is unbelievable. Please keep my request. 001) Split Function in VBA with Multiple Delimiters like ";:*_, ./#@". I mean to say, how to split alphanumeric contents in Excel with split function in VBA those have multiple Delimiters. 002) How to convert Currency to Word through VBA? (Like 1,000,000 = One Million Dollar and Zero Cent Only) 003) How to find out Prime Numbers through VBA? (Like 3, 7, 11, 13, 17, 19, 23, 29 and so on).

[@kartickchakraborty9135]

Hello Sir, Recently, I've faced some problems in my office work. In order to solve those problems, I came up with 3 ideas. But due to shallow knowledge in VBA, I couldn't implement those ideas in reality to sort out those issues. I've given my 3 questions below one by one. I believe, you'll definitely help me. 001) Is it possible to create Spilled Array (Dynamic Array) like function in VBA. I mean to say creating User Defined Function like Spilled / Dynamic Array Functions (Filter, RandArray, Sequence, Sort, SortBy and Unique Functions) in Excel (Office 365 Version). 002) How do I split First Names, Middle Names (If Available) and Last Names with one single User Defined Function in VBA? Is it also possible in VBA? 003) How to use VBA Split Function with Multiple Delimiters?

[@seleman-MW]

my problem "is Out of memory" whenever i try to open vba on excell

[@deprive-999x]

I'm getting runtime error 91 excel on mac not on windows

[@sarahmustafa959]

I need help. Can you please help

[@gokuls9557]

How to solve catastrophic failure error in vba

[@philipmcdonnell7168]

I don't use the watch window or Parent anything like often enough.

[@noneyabeezwax8865]

Wow!

[@Excelmacromastery]

Glad you liked it.

[@karmusinghsiddhu190]

sir can pls correct for me Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Rg As Range Dim G As Integer Dim varno As Long 'With Sheet1 'Range("J5:J5").AutoFill Destination:=Range("j5:j213") 'Range("L8").Formula = "=IF(AND(F5="",G5="",H5=""),"",I4+F5-G5-H5)" 'Range("l5").Value = "=(IF(AND(F5="",G5="",H5=""),"",I4+F5-G5-H5)" Range("A2").Formula = "=TRANSPOSE(P2)" Range("J4").Formula = "=SUM(G4-H4-I4)" Range("L3").Formula = "=SpellNumber(L2)" Range("M2").Formula = "=NOW()" ' Range("A1").Formula = "=TRANSPOSE(FO1)" Range("D2").Formula = "=COUNTA(D5:D217)" Last Row (Total =I4+F5-G5-H5)" End Sub

[@BertandRussell]

💖💖💖💖💖💖💖💖💖💖💖💖💖💖💖💖💖

[@Excelmacromastery]

Thanks

[@rahman_darb]

Thank you sir

[@Excelmacromastery]

Welcome