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

#Excel #ExcelTips #ExcelTutorial

[BartFlossom]

This course playlist is the most useful tutorial I have found. It has become my 'bible'.

[Ali-Jamal]

From Iraq - Thank you very much for your kind efforts

[nelly]

Thank you...Finally!! VBA Course with applicable examples. Your explanation is concise and your teaching is preemptive.

[akshayaispisces]

You are a born teacher. You have a flair for teaching in easy & simple way. Keep it up

[inbalajis]

Thanks brother.... very helpfull ...post More VBA videos

[umeshroy]

Sumit bro..i watch your video every day

[stephenhammond]

Could not get the code to add a sheet to the end of a workbook to work. In fact, most of the things I tried using the word "sheets" failed. I have an old 2013 version of Excel and thought maybe it was corrupt. After about an hour I finally realized that I had renamed the module the code was in to "sheets". I changed the module name and everything now works fine. Lesson learned.

[alokbharti]

can we give print command to sheet B specific content (which is hidden) from sheet A

[varunsinghi]

Hi Sumit, when trying to change name of the sheet in Properties window, i am getting error message "Invalid Property value". How can I fix it ?

[maheshsinghbhati]

Can we copy from excel and paste in outlook email??

[vanacharlasaipavankumar]

why when you specify a single cell range it copied whole content in the work sheet

[jordannilsson]

I just tried to do Worksheets("Sheet1").Select and the next line of code is Worksheets("Sheet2"). Select FALSE. The next line of code is Range("A1").Value = 1. In the video you said that whatever I put into one sheet, it will do in the other. This didn't happen with my code. Can you help me do this?