Free Excel VBA Course #9 - Working with Worksheets using VBA in Excel (Select, Add, Delete, Copy)

[@BartFlossom]

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

[@nelly7850]

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

[@Ali-Jamal90]

From Iraq - Thank you very much for your kind efforts

[@umeshroy6898]

Sumit bro..i watch your video every day

[@inbalajis1861]

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

[@pradnyahasabnis1107]

Very nice explanation. Thank you.

[@deepaktambe8043]

Very useful! Thanks

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@kanchanthapa4255]

nicely explained

[@GoGetSP]

Hi Sumit, I entered Sub Refersheet() Charts.Add After:=Sheets(Sheets.Count) End Sub It is adding a chart just before the last Worksheet but not as the last Chartsheet? Why?

[@mateuslage8233]

Hello, thanks for the help!!! For me was not very clear the difference between the sheet and worksheet during the codes. If you could clarify I will be glad! Thanks again

[@trumpexcel]

Sheets = Worksheets and Chartsheets. Chartsheets are not commonly used, so in general, Sheets and Worksheets can be used interchangeably

[@alokbharti5547]

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

[@stephenhammond1745]

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.

[@maheshsinghbhati4282]

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

[@abhinaygarg7029]

Thank you so much...

[@varunsinghi2710]

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 ?

[@vanacharlasaipavankumar6331]

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

[@manishkumarchd]

great

[@jordannilsson2235]

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?

[@againagainagainagain.]

As in Line 1 and Line 2, both sheets selected. 3rd Line is : selection.value = 1

[@againagainagainagain.]

Sub Sheets_Selection() Sheet1.Select Sheet2.Select False Selection.Value = 123 End Sub