Скачать или смотреть Free Excel VBA Course #9 - Working with Worksheets using VBA in Excel (Select, Add, Delete, Copy)

In this video, I will show you how to work with worksheets in Excel using VBA.

The following topics are covered in this video:
-- How to Add a new worksheet
-- How to add a new sheet before and after a specific worksheet
-- How to select/activate existing worksheets
-- How to delete a worksheet using VBA
-- How to copy a sheet using VBA
-- How to Rename a worksheet in Excel using VBA

✅ VBA Course Download files: https://trumpexcel.com/course-downloa...

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

-------------------------------------------------------------------------------------
00:00 - Introduction to worksheets and chart sheets
01:26 - Referring to worksheets using collections
05:14 - Using code names vs. sheet names
08:46 - Adding new worksheets
11:35 - Positioning worksheets in workbook
14:35 - Deleting worksheets
17:38 - Copying worksheets
19:60 - Moving and renaming worksheets
21:17 - Hiding and unhiding worksheets
-------------------------------------------------------------------------------------

#Excelvba #ExcelTips #ExcelTutorial