I've been doing VBA for the office for a while, and I have still learned some invaluable lessons from these videos. You can feel the genuine excitement through all the tips and tricks, and the professionalism of the presentation surpasses most class rooms - that's some damn good VBA!
It's the world's best online training institute. Andrew, Almighty has made you very talented. Please keep on sharing the knowledge. May Almighty bless you.
Andrew I got a new analyst job just because I manipulated the interview only after watching few of your videos and later on I learn before I actually started the job lol. Anyways lot of analysts actually suggest watching you. Cheers Mate!!
I search tutorial, and in trial and error I have found that yours are the best. I no longer waist time watch other ones. I've watch and take notes on about a dozen of your videos. It's allow me to improve process and work. I now have code to do just about every thing I need to do, even opening up a text file. LOL... But I open several at a time. YOU ARE THE BEST, THANK YOU. I just bought your book Introduction to Excel VBA.
I'm only on video 6/77 but I feel like I've already learned so much from watching this. Kudos to the instructor for making the lesson so easy to understand.
WiseOwl, this instructor is good. He has left nothing untouched, very thorough and direct. Thank you so much for sharing the knowledge. You are blessed.
Although this is a few years ago now lol, I have found this to be the best to learn from.Lots of things are repeated over and over again, which is great because it is not assumed you know what you are doing. I have watched 3 other tutors, watching so many of their videos, but at last I have found this. very happy
Hi Jo, these videos are getting a bit old now, you're right! We recently updated the earlier videos in this series and created a separate online tutorial covering the basics of VBA www.wiseowl.co.uk/online-training/excel-vba/ The tutorial covers everything up to around Part 19-20 of the older series and has downloadable files and exercises. Just in case you were looking for something a little more up to date!
As a Recent Graduate in Business and Finance, VBA/SQL are industry standard skills one must have in the field of finance. Thank you for your excellent teaching!
I'm working as a mechanical engineer and use Excel as my calculation and reporting tool along with Word so as you say VBA is will enhance my productivity, that's for sure. I see that one has to be careful with worksheet names ( between what the user sees and what is ). I'm going to contribute to your cause for sure. I'm learning Python as well
I immensely appreciate your content delivery. As a presenter, you have a beautiful voice which makes learning enormously motivating as well as inviting. Thanks for putting in so much work in these videos; one also learns about presentation skills thorough your videos. I am from the UK, and I really hope to see you one day. Thanks, Vijay
excellent teaching! I started with no knowledge of VBA, but your teaching is very clear ! I have learnt a lot, thank you very much! After VBA, I will watch your SQL vedios.
Your lessons are extremly usefull for learning VBA. I am Ukrainian, actualy i don't understand completly your language, but i understand code language VBA. Thanks for good lessons, the first one is VBA and the second one is English.
Thank you so much, Wise Owl, Before I was afraid of VBA until that I ask ChatGPT, How can I learn VBA, and it gave me your TH-cam channel, Since this moment, I feel good with VBA and I learn more every day.
I am watching this TH-cam video for learning about this VBA, and truly, I appreciate all your instructing... I appreciate you put all together, and explaining this hard programing easy. I am Blessed to know you, WiseOwl. thank you!
Fantastic course. Not only for beginners - I have been using VBA for long time by now, but I have learned new tricks and generally the course let me a kind of declutter my knowledge. Thanks a million.
Thank you for this video and your great lessons. As many other people already mentioned, you're extremely clear and the way you explain VBA is very easy to follow.
WiseOwl thanks for the effort you put into your work! Really appreciate your tutorials and it is not only useful but even fun to watch! Only the best to you!
Sir. thank you are so brilliant, the way you teach is very easy to learn keep up the wonderful job. God bless you and congratulatios. You have a new friend in Colombia.
Dear Andrew, I never found a teacher clear, simple, practical, competent and that made me passionate about a subject like you. I no longer really know how to thank you for the joy with which I watch your videos, which make me learn something more each time .. You are really fantastic! A question please: is there a way when VBA goes wrong, instead of pointing out in yellow the whole line of code, to highlight the single part of the line where there is the error? Thanks again. Ciao!
Great videos, no doubt the best in TH-cam for learning VBA! Apparently, you can change CodeNames programatically, for instance: Sub change_code_name() Dim wbk As Object, sheet As Object ActiveWorkbook.VBProject.Name = "VBAProject" Set wbk = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.CodeName) wbk.Name = "wbk_code_name" Set sheet = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.Sheets(1).CodeName) sheet.Name = "sheet_code_name" End Sub (access to the VBAProject is required, check macro settings).
I really love your tutorials! The other 5 so far I have been able to work alongside you and do what you're doing to learn from doing it myself, but with this one, I couldn't really do that because I didn't have the base excel file. That is literally my only complaint so far! Considering this video is almost five years old though, I don't see you adding a download link in your description! Haha
Just coming back to using Excel and VBA after several years and away and agree with you on this one. Not sure why manipulating Charts is here when no mention of how to create them in the first place. Had to do some study elsewhere on how to create a Chart just so I could follow along with this tutorial.
14:42 If you are unable to change the code name because you are getting the message "invalid property value" follow these instructions. In your workbook, go to Options -> Trust Center ->Trust Center Settings and check the box for "Trust access to the VBA project object model"
Wise Owl, great VBA videos after watching your videos along with my VBA book I feel I'm in pretty good shape. In your VBA video #6 you say you are going to do a video with how to save and close documents, I was wondering will that video also explain Dim for variables? Thanks for your videos looking forward to the new ones.
35:42 You can't write code to change the codename? I am sure Andrew can do anything, maybe if you trust access to the VBA project model. Your tutorials are just amazing. Let me say that again. Your tutorials are just amazing, even my dog thinks so.
Really Comprehensive and easy to understand. But is there any fast way to remember these functions? or I guess I just need to have more practices to get acquaint and familiarized with these functions :)
In the beginning of the lesson, where did the first chart come from? How did you create it? Regarding Choosing Where to Insert Worksheets, the tab names of the three new sheets appear in descending order. Without using VB Editor, how do I program Excel so they appear in ascending order? And how do I program it so that the new worksheet tab in 16:50 reads Sheet1 instead of Sheet5?
Hello Andrew,First of all thank you so much for posting these videos. They are so helpful for me. I appreciate your work. But I also need some other help. I have an interview at the end of this month and since I have to write a test along with my personal interview, I want to know whether these videos will be enough for me to learn VBA excel or should I refer some other things also?
Thank you for the reply! I was trying to do one task but couldn't complete it. Can you help me in it? My question is- I have to transfer data from one workbook to another workbook automatically with a user friendly interface so that should it allows user to select the data for copying) and also if there are any blank fields in the data, they should be left blank.
Very very thanks Wiseowl for these videos. I have one doubt from this session (Part-6). How can you delete multiple sheets, let's say: to delete 3 selected worksheets in same workbook. Is there a single command to execute this in one go.
Hi ! Amazing videos! One question: Is there anywhere I can download/see all the codes written during the videos (just in txt. format e.g.), so I don't have to go through the video again to see the syntax of something specific?
Great video! Is there a way to close a worksheet before the workbook is closed? I have two macros that hide and unhide a worksheet, but I'm having trouble finding a way to have it automatically close when the entire workbook is closed. Not sure if that makes sense or not. Thanks in advance!
Hi WiseOwl, after thanking you for your great efforts, I have learned a lot from your videos! Just a quick notification, in the above video "Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets", at min 32, video stops loading or working and it freezes for ages, any idea please about this issue, or can you re-upload it? Thanks, Huda
I'm on Office 2016 and this is all very relevant however not sure that the distinction between "charts" and "worksheets" are relevant as seems you can combine one into the other
Hi, thank you very much for this brilliant video, which helps a lot. However, here i got a little confused with the intellisense, when i wrote [ worksheets("sheet1"). ] it didn't show up and after i typed copy by myself and hit space once the arguments for before or after didn't show up either. so should it be like this? Look forward to hearing from you.
Hi Andrew, Thanks for your wonderful tutorials. Today I am bamboozled by a simple code. Worksheets(paEXtract).Activate, generates a runtime error 13. I am not sure what is wrong. Could you pleaser help? Thanks
Hi Andrew, watching this video reminded me of something that has come up, (for me), in many of your videos. That is the question of indices and whether they are 0 based or 1 based? I sometimes get caught out on this, is there a rule or a way of telling when an index is one or the other? Thanks.
Sir, thanks a lot for these coursework... I am following this series from Part 1.... But I am facing a problem with Sheets() command... this is showing compile error.... I am using office 2007...
Hi Andrew great tutorial. one question comes up, Is it possible to change visible property to veryhidden and than disable for other users to change this property ?
Hi Andrew, thank you for the lovely tutorial. Old is gold so the this and other tutorials in this series never get old. I have a short question. I wrote a code which is copying specific data from one workbook (only one sheet) and copies it to a new workbook in different sheets depending upon some criteria. The code works perfectly fine till it inserts fifth sheet (data copying works fine for fifth sheet). Only after that when I expect the code to insert another sheet (sheet 6), I get "Run-time error '9', Subscript out of range". I am copying the section of the code which inserts new sheet in the Output_workbook.xlsm. ' here j takes the value of sheets count when the code starts and stays in the same index number j = Workbooks("Output_workbook.xlsm").Sheets.Count Workbooks("source_workbook.xlsm").Worksheets("KgKw").Activate If Range("A2").Offset(i, 2).Value Range("A2").Offset(i - 1, 2).Value And Range("A2").Offset(i, 2).Value "" Then ' i is the data counter in the source_workbook.xlsm
Workbooks("Output_workbook.xlsm").Sheets(j).Range("A:D").EntireColumn.AutoFit Workbooks("Output_workbook.xlsm").Sheets.Add after:=Sheets(j) ' after inserting the new sheet, value of j is being updated j = Workbooks("Output_workbook.xlsm").Sheets.Count
End If Could you give any hints as why the code fails after inserting five sheets? Thank you, Zubair
Hi Zubair! You've been very careful to explicitly reference the sheets collection in the respective workbooks except in one place: Workbooks("Output_workbook.xlsm").Sheets.Add after:=Sheets(j) Try this: Workbooks("Output_workbook.xlsm").Sheets.Add after:=Workbooks("Output_workbook.xlsm").Sheets(j) I hope it helps!
Best channel to learn VBA. I learnt from this a lot.
Thanks so much, I appreciate the comments!
My company paid like $1000 dollars for me to take a VBA course that was half as useful as these videos. You are doing a wonderful thing posting these.
I've been doing VBA for the office for a while, and I have still learned some invaluable lessons from these videos. You can feel the genuine excitement through all the tips and tricks, and the professionalism of the presentation surpasses most class rooms - that's some damn good VBA!
Simply fantastic! Clear, simple, gradual, essential. Thanks endless!
It's the world's best online training institute.
Andrew, Almighty has made you very talented.
Please keep on sharing the knowledge.
May Almighty bless you.
Andrew I got a new analyst job just because I manipulated the interview only after watching few of your videos and later on I learn before I actually started the job lol. Anyways lot of analysts actually suggest watching you. Cheers Mate!!
I search tutorial, and in trial and error I have found that yours are the best. I no longer waist time watch other ones. I've watch and take notes on about a dozen of your videos. It's allow me to improve process and work. I now have code to do just about every thing I need to do, even opening up a text file. LOL... But I open several at a time. YOU ARE THE BEST, THANK YOU. I just bought your book Introduction to Excel VBA.
Thanks to the best VBA teacher worldwide. I have really watched many tutorials. Your ones are undoubtedly the best.
🌟🌟🌟 🌟 🌟 🌟 🌟 🌟 🌟 🌟
I'm only on video 6/77 but I feel like I've already learned so much from watching this. Kudos to the instructor for making the lesson so easy to understand.
Same
In my job VBA is used everyday and I had no zero experience prior so thanks to you I'm not fired :)
Andrew, you are simply class.
WiseOwl, this instructor is good. He has left nothing untouched, very thorough and direct.
Thank you so much for sharing the knowledge. You are blessed.
Although this is a few years ago now lol, I have found this to be the best to learn from.Lots of things are repeated over and over again, which is great because it is not assumed you know what you are doing. I have watched 3 other tutors, watching so many of their videos, but at last I have found this. very happy
Hi Jo, these videos are getting a bit old now, you're right! We recently updated the earlier videos in this series and created a separate online tutorial covering the basics of VBA www.wiseowl.co.uk/online-training/excel-vba/
The tutorial covers everything up to around Part 19-20 of the older series and has downloadable files and exercises.
Just in case you were looking for something a little more up to date!
As a Recent Graduate in Business and Finance, VBA/SQL are industry standard skills one must have in the field of finance. Thank you for your excellent teaching!
I don't know what to say except that it can't be better than this.
May God bless the Very amazing Tutor.
Tanks of thanks.
You've got talent for teaching ! I've been playing with Excel for years, but never VBA. I see the power now ! You can do anything and much faster !
I'm working as a mechanical engineer and use Excel as my calculation and reporting tool along with Word so as you say VBA is will enhance my productivity, that's for sure. I see that one has to be careful with worksheet names ( between what the user sees and what is ). I'm going to contribute to your cause for sure. I'm learning Python as well
Hello you all.... SIMPLY one of best channels i have seen so far that covers the Excel VBA, Thank you .
I immensely appreciate your content delivery. As a presenter, you have a beautiful voice which makes learning enormously motivating as well as inviting. Thanks for putting in so much work in these videos; one also learns about presentation skills thorough your videos. I am from the UK, and I really hope to see you one day. Thanks, Vijay
excellent teaching! I started with no knowledge of VBA, but your teaching is very clear ! I have learnt a lot, thank you very much! After VBA, I will watch your SQL vedios.
Your lessons are extremly usefull for learning VBA.
I am Ukrainian, actualy i don't understand completly your language, but i understand code language VBA. Thanks for good lessons, the first one is VBA and the second one is English.
Thank you so much, Wise Owl, Before I was afraid of VBA until that I ask ChatGPT, How can I learn VBA, and it gave me your TH-cam channel, Since this moment, I feel good with VBA and I learn more every day.
I'm really happy to hear that you're finding the VBA videos useful! Thanks for taking the time to leave a comment and for watching!
Your teaching style is excellent, thank you for taking the time to put these together!
Excellent lesson, simply and concisely delivered. Thank you for sharing your MS Excel knowledge with your viewers.
All your VBA Videos are very resourceful ... i must say you have tried to teach minute details in your videos... thanks a lot
I am watching this TH-cam video for learning about this VBA, and truly, I appreciate all your instructing... I appreciate you put all together, and explaining this hard programing easy. I am Blessed to know you, WiseOwl. thank you!
Thank you so much for these tutorials! So easy to follow and helpful - should have discovered these videos years ago !!!
Thanks Gerald! Happy to hear that you're finding them useful!
My favorite youtube tutorials vba and sql. You are awesome, Andrew!
Fantastic course. Not only for beginners - I have been using VBA for long time by now, but I have learned new tricks and generally the course let me a kind of declutter my knowledge. Thanks a million.
Thank you for this video and your great lessons. As many other people already mentioned, you're extremely clear and the way you explain VBA is very easy to follow.
Your tutoriels are so clear and ease to follow! Thank you so much for doing that for us Andrew!
honestly your videos are amazing. i never expected myself to learn as quick. thank you very much!
WiseOwl thanks for the effort you put into your work! Really appreciate your tutorials and it is not only useful but even fun to watch! Only the best to you!
Thank you Aleksandr! I'm happy that you're enjoying the videos and thank you for taking the time to leave a comment!
WiseOwl who is this instructor? He is brilliant! I have learned so much!
Haha that response truly made my day!
I SO AGREE! hes absolutely amazing. So precise and thorough, and usable examples that freaking WOrk!!! tytytytytytytyty
Not Batman but New version: Owlman
I would just like to thank you for your awesome tutorials! You Sir, have some great teaching skills and voice :D
Thanks for your video, I learn your video every evening. You really help me a lot!
You are Amazing.
Hope you have a wonderful life.
Sir. thank you are so brilliant, the way you teach is very easy to learn
keep up the wonderful job. God bless you and congratulatios.
You have a new friend in Colombia.
The way you teach is awesome! Great work!
it's amazing... I'm loving it.. the way trainer explain, that is awesome..😊
I find this very helpful and thank you for sharing the knowledge.
Super teaching technique, very pleasing voice. Thank you.
Yes, it's a briliant tutorial. Thanks so much!
Andrew,
Brilliant Teaching. I enjoy your tutorials very much.
This is AMAZING. Genuinely thank you so much
I loved the refering to sheets by code method!
This tutor is awesome
Going through your wonderful tutorials... well paced with useful contents. Thanks for sharing the knowledge and time.
excellent videoes on VBA. Thank you for your valuable time for making and sharing such nice videoes..!!!
Bought a book! Yay (goosebumps!!) can’t wait to study it! Will check the website for everything else for sure! Thank you!!;)
thank you sir. Very useful as usual ..keep it up the good work please for us. I am fan of your teaching style and knowledge.
Dear Andrew, I never found a teacher clear, simple, practical, competent and that made me passionate about a subject like you. I no longer really know how to thank you for the joy with which I watch your videos, which make me learn something more each time .. You are really fantastic!
A question please: is there a way when VBA goes wrong, instead of pointing out in yellow the whole line of code, to highlight the single part of the line where there is the error?
Thanks again. Ciao!
Thank you for an interesting video. I've been writing macros for some time, but the part related to using worksheets' codename property was new to me.
best tutorial ever....head-chop guaranteed
thank you Andrew....
sharing the wisdom
Awesome once Again! 🙏
Thanks again for watching!
I love you man!! The best tutorial ever! If you have got any book written for coding or any other excel tips please let me know!!;)
Great videos, no doubt the best in TH-cam for learning VBA!
Apparently, you can change CodeNames programatically, for instance:
Sub change_code_name()
Dim wbk As Object, sheet As Object
ActiveWorkbook.VBProject.Name = "VBAProject"
Set wbk = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.CodeName)
wbk.Name = "wbk_code_name"
Set sheet = ActiveWorkbook.VBProject.VBComponents(ActiveWorkbook.Sheets(1).CodeName)
sheet.Name = "sheet_code_name"
End Sub
(access to the VBAProject is required, check macro settings).
Thanks for sharing! Indeed you can!
Great work! Thank you!
Thanks Noel!
So nice tutor. Thank you so much
I certainly did find that useful. Thanks!
most amazing vba
I really love your tutorials! The other 5 so far I have been able to work alongside you and do what you're doing to learn from doing it myself, but with this one, I couldn't really do that because I didn't have the base excel file. That is literally my only complaint so far! Considering this video is almost five years old though, I don't see you adding a download link in your description! Haha
Just coming back to using Excel and VBA after several years and away and agree with you on this one. Not sure why manipulating Charts is here when no mention of how to create them in the first place. Had to do some study elsewhere on how to create a Chart just so I could follow along with this tutorial.
This guy is awesome!
Great videos. Learned so much. Do you have a video on how to select all sheets in a workbook and format all cells in a range?
really awesome, more plentiful than is usual or necessary.
14:42 If you are unable to change the code name because you are getting the message "invalid property value" follow these instructions. In your workbook, go to Options -> Trust Center ->Trust Center Settings and check the box for "Trust access to the VBA project object model"
very good explained, Thanks a lot
Wise Owl, great VBA videos after watching your videos along with my VBA book I feel I'm in pretty good shape.
In your VBA video #6 you say you are going to do a video with how to save and close documents, I was wondering will that video also explain Dim for variables? Thanks for your videos looking forward to the new ones.
Another great tutorial!
Thank You! Awesome Tutorial
God send you to teach... Wow!!
35:42 You can't write code to change the codename? I am sure Andrew can do anything, maybe if you trust access to the VBA project model.
Your tutorials are just amazing. Let me say that again. Your tutorials are just amazing, even my dog thinks so.
try ActiveWorkbook.VBProject.VBComponents("Sheet1").Name = "NewCodeName" should do it. :)
Really Comprehensive and easy to understand. But is there any fast way to remember these functions? or I guess I just need to have more practices to get acquaint and familiarized with these functions :)
your videos are the best....
Thank You! I can not afford to pay for these instructions. In this instance the old maxim " you get what you pay for" does not apply.
really brilliant
excellent tutorial... thanks heaps.
Thanks
You're welcome!
Great teaching. When new vba tutorial?
In the beginning of the lesson, where did the first chart come from? How did you create it?
Regarding Choosing Where to Insert Worksheets, the tab names of the three new sheets appear in descending order. Without using VB Editor, how do I program Excel so they appear in ascending order?
And how do I program it so that the new worksheet tab in 16:50 reads Sheet1 instead of Sheet5?
22:04 😊
Hello Andrew,First of all thank you so much for posting these videos. They are so helpful for me. I appreciate your work. But I also need some other help. I have an interview at the end of this month and since I have to write a test along with my personal interview, I want to know whether these videos will be enough for me to learn VBA excel or should I refer some other things also?
Thank you for the reply!
I was trying to do one task but couldn't complete it. Can you help me in it? My question is-
I have to transfer data from one workbook to another workbook automatically with a user friendly interface so that should it allows user to select the data for copying) and also if there are any blank fields in the data, they should be left blank.
I dont know why , but is am getting error called "object required", can you please help
Very very thanks Wiseowl for these videos.
I have one doubt from this session (Part-6). How can you delete multiple sheets, let's say: to delete 3 selected worksheets in same workbook. Is there a single command to execute this in one go.
Hi ! Amazing videos!
One question: Is there anywhere I can download/see all the codes written during the videos (just in txt. format e.g.), so I don't have to go through the video again to see the syntax of something specific?
Great video! Is there a way to close a worksheet before the workbook is closed? I have two macros that hide and unhide a worksheet, but I'm having trouble finding a way to have it automatically close when the entire workbook is closed. Not sure if that makes sense or not. Thanks in advance!
Hi WiseOwl, after thanking you for your great efforts, I have learned a lot from your videos!
Just a quick notification, in the above video "Excel VBA Introduction Part 6 - Worksheets, Charts and Sheets", at min 32, video stops loading or working and it freezes for ages, any idea please about this issue, or can you re-upload it?
Thanks,
Huda
I'm on Office 2016 and this is all very relevant however not sure that the distinction between "charts" and "worksheets" are relevant as seems you can combine one into the other
Hi, thank you very much for this brilliant video, which helps a lot. However, here i got a little confused with the intellisense, when i wrote [ worksheets("sheet1"). ] it didn't show up and after i typed copy by myself and hit space once the arguments for before or after didn't show up either. so should it be like this? Look forward to hearing from you.
thank you
Thank you!
Very good online tutorial! By the way, where is the link to download data for practice?
ok, thanks!
Hi Andrew,
Thanks for your wonderful tutorials. Today I am bamboozled by a simple code. Worksheets(paEXtract).Activate, generates a runtime error 13. I am not sure what is wrong. Could you pleaser help?
Thanks
very helpful vedio
Full of Detailing ... so nothing is left behind ...
ty very much , and how can we change the CodeName of a newsheet?
38:34 😊
Hi Andrew, watching this video reminded me of something that has come up, (for me), in many of your videos. That is the question of indices and whether they are 0 based or 1 based? I sometimes get caught out on this, is there a rule or a way of telling when an index is one or the other? Thanks.
It's simple. Arrays are zero based, unless you make them not to be so. Collections (and I think everything else) is one based.
Sir, thanks a lot for these coursework... I am following this series from Part 1.... But I am facing a problem with Sheets() command... this is showing compile error.... I am using office 2007...
Hi Andrew
great tutorial. one question comes up, Is it possible to change visible property to veryhidden and than disable for other users to change this property ?
***** yes ,definitely helps. I keep watching your videos !
Hi Andrew, thank you for the lovely tutorial. Old is gold so the this and other tutorials in this series never get old.
I have a short question. I wrote a code which is copying specific data from one workbook (only one sheet) and copies it to a new workbook in different sheets depending upon some criteria. The code works perfectly fine till it inserts fifth sheet (data copying works fine for fifth sheet). Only after that when I expect the code to insert another sheet (sheet 6), I get "Run-time error '9', Subscript out of range". I am copying the section of the code which inserts new sheet in the Output_workbook.xlsm.
' here j takes the value of sheets count when the code starts and stays in the same index number
j = Workbooks("Output_workbook.xlsm").Sheets.Count
Workbooks("source_workbook.xlsm").Worksheets("KgKw").Activate
If Range("A2").Offset(i, 2).Value Range("A2").Offset(i - 1, 2).Value And Range("A2").Offset(i, 2).Value "" Then ' i is the data counter in the source_workbook.xlsm
Workbooks("Output_workbook.xlsm").Sheets(j).Range("A:D").EntireColumn.AutoFit
Workbooks("Output_workbook.xlsm").Sheets.Add after:=Sheets(j)
' after inserting the new sheet, value of j is being updated
j = Workbooks("Output_workbook.xlsm").Sheets.Count
End If
Could you give any hints as why the code fails after inserting five sheets?
Thank you,
Zubair
Hi Zubair! You've been very careful to explicitly reference the sheets collection in the respective workbooks except in one place:
Workbooks("Output_workbook.xlsm").Sheets.Add after:=Sheets(j)
Try this:
Workbooks("Output_workbook.xlsm").Sheets.Add after:=Workbooks("Output_workbook.xlsm").Sheets(j)
I hope it helps!
@@WiseOwlTutorials thank you for the hint. I actually figured it out and now the code is completely error free.
@@zubairkahn1983 Happy to hear you found a solution!