Excel VBA for Post-Beginners: (2/6) Record Code to Duplicate Sheets

If you know the basics of Excel VBA and want to take the next step, this series is for you. We take an everyday task – creating reports from a database – and look at how to complete it using Excel VBA. The series consists of 6 videos, including the introduction.

You can download practice files from the website here:

Watch another VBA for beginners series here:

If you develop confidence in these areas, it won’t just save you time, it will transform the way you work with Excel spreadsheets.

I would love to hear from you – did the series help, and what are you trying to get done using Excel VBA?

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know

For regular spreadsheet hints and tips and more on the #ExcelRevolution:

[TigerSpreadsheetSolutions]

To control the order of the sheets after sheet duplication:


Try changing this line of code:
Sheets("Test").Copy After:=Sheets(2)

To this:
Sheets("Test").Copy - 1)

Or this:
Sheets("Test").Copy

Worksheets.Count tells us the number of sheets in the workbook. By using Worksheets.Count in the brackets, we are telling Excel to copy the sheet in after the last sheet in the workbook.


See this video for more on the topic:

[maurocastagnera]

Hi Chris, I just started the first lesson for post-beginners today and I'm very happy to continue your lessons, that every time make me discover more and more interesting things about VBA. Congratulations again for your excellent teaching method and how you have structured this great course! Thanks again and see you soon.

[tompendrey]

Really enjoying these lessons - very helpful and clear. As an engineer, I often do a lot of work with spreadsheets and I have for a long time wanted to learn VBA. These videos are the start of that journey for me.

[haroldkingsbury]

Chris, thank you for your efforts to help us, the public, to use and understand the potential of VBA. You are a TIGER.

[Brian-vemi]

I can't believe you created this whole series! I can't wait to see what I will learn! Thanks again Chris, your awesome!

[azizazhar]

I used this method for printing every sheets of my excel file and it was easier by clicking one single button to print out multiple sheets at once! Thank you for this video 👏

[chiuhsiacheng]

Hi Christ I am so glad I began my VBA journey with you. I enjoyed your lessons and for the very first time regaining my faith in learning VBA programming. Excellent teaching !!!

[shooterrick]

Thank you, these tutorials are a lifesaver. The materiel provided by my school isn't very thorough so I'd be lost without this.

[eberkamuti]

it's amazing how you make it seem so simple to a seemingly overwhelming VBA coding

[Nessus]

Very good. Very pleasant voice and personality - just right for instruction!

[shreekantk]

This learning package actually gave me a great start in learning MS Excel you very Much

[ShelleyPatterson]

I am so happy that I found your tutorials. They are very information and easy to follow. I know that Excel can do what I want it to do but I will have to teach myself VBA first. Wish me luck with my monster spreadsheet!!

[augustadesousa]

Great course. I am new using VBA language and your teaching techniques are indeed very helpful. Thanks a lot. Keep posting videos like these, please.

[BigIdeasLittleTime]

Appreciate all your time to put these together - Very Helpful!

[cycleSCUBA]

Very impressed Chris. Your explanations and teaching style make this easy to understand and memorise what is a very complex part of Excel.
I'll only be using Tiger Excel for VBA tution (and all aspects of Excel). 10/10

[hoangvietphapable]

The great teacher I've ever seen on Youtube. Hope there will have more lessons from you.

[IFCSAT]

Awesome Chris! So incredibly helpful and easy to understand. I really enjoy your delivery, you get right to the point and break it down to its simplest concept. It really makes it digestible to a beginner like myself. Thank you!

[smallhhy]

You are an outstanding teacher. It is so nice to follow your courses. Thank you very much - I really appreciate to watch the movies.

[missnobody]

I'm binge watching this channel during lockdown rather than binge watching Netflix

[Nicole-xyqz]

This is exactly what I needed, thank you