You're very welcome Darryl! I am really loving showing how simple things can be with VBA, though, of course, it gets complex fast, but things like creating workbooks is easier than many think. :)
Put an Array("Sheet1","Sheet2") into the copy method - I haven't seen this specific code for a while, but that should do the trick. If it doesn't get you all the way there, just ask in our forum and include any code you already have and it will be easier to help :) TeachExcel's Excel Forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment_reply
Hello thanks for the tutorial but just want to ask, what is the code for this scenario. I want to create a new workbook with the active sheet?. I have sheets from January - december if I want to create a new workbook for The active sheet February?
Well I don't want to give a firm date, but I do believe that I now have everything that remains to be done planned out, with the exception of the specifics of the practical tutorials. The core 100 tutorials are finished and uploaded though and I included a course status and update in this weeks newsletter, but if you aren't signed up for that, you can just click the link to the Blog on teachexcel.com and the latest post talks about it.
Hi could you please help on how to move sheet 1 and sheet 2 simultaneously to another workbook since as you mentioned that array is not working. Thanks for this wonderful video❤
The Power Of A Few Lines Of VBA Code!!Cool Tutorial...Thank You Sir :)
You're very welcome Darryl! I am really loving showing how simple things can be with VBA, though, of course, it gets complex fast, but things like creating workbooks is easier than many think. :)
Really nice. You have explained so clearly
This is so useful thank you, Is it possible to only copy certain rows or even cells from a row into the new workbook?
This is really helpful. You made my day
I'm really glad to hear it :)
Nice tips. VBA is so useful and fun. Thanks for sharing :)) Thumbs up!!
Thanks Wayne! Couldn't agree more! Glad you think so :)
This is so useful. Thank you!
Glad you think so! You're very welcome Justin!)
Such a good video, so clear and nicely explained
This is great, thank you. How would I adjust the code to copy across more than one worksheet?
Put an Array("Sheet1","Sheet2") into the copy method - I haven't seen this specific code for a while, but that should do the trick. If it doesn't get you all the way there, just ask in our forum and include any code you already have and it will be easier to help :) TeachExcel's Excel Forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment_reply
How would i copy multiple sheets to a new workbook? what would I adjust the Worksheets("sales1").copy code to?
Hello thanks for the tutorial but just want to ask, what is the code for this scenario. I want to create a new workbook with the active sheet?. I have sheets from January - december if I want to create a new workbook for The active sheet February?
Okay got it. It should be
Activesheet.Copy
What is the use of 51?
When do u think the course will be available ?
Well I don't want to give a firm date, but I do believe that I now have everything that remains to be done planned out, with the exception of the specifics of the practical tutorials. The core 100 tutorials are finished and uploaded though and I included a course status and update in this weeks newsletter, but if you aren't signed up for that, you can just click the link to the Blog on teachexcel.com and the latest post talks about it.
Hi could you please help on how to move sheet 1 and sheet 2 simultaneously to another workbook since as you mentioned that array is not working. Thanks for this wonderful video❤