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?
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
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.
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?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
This course playlist is the most useful tutorial I have found. It has become my 'bible'.
Thank you...Finally!! VBA Course with applicable examples. Your explanation is concise and your teaching is preemptive.
You are a born teacher. You have a flair for teaching in easy & simple way. Keep it up
From Iraq - Thank you very much for your kind efforts
Sumit bro..i watch your video every day
Thanks brother.... very helpfull ...post More VBA videos
Very nice explanation. Thank you.
Very useful! Thanks
Thanks so much.
nicely explained
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?
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
Sheets = Worksheets and Chartsheets. Chartsheets are not commonly used, so in general, Sheets and Worksheets can be used interchangeably
can we give print command to sheet B specific content (which is hidden) from sheet A
Can we copy from excel and paste in outlook email??
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.
Thank you so much...
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 ?
why when you specify a single cell range it copied whole content in the work sheet
great
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?
As in Line 1 and Line 2, both sheets selected. 3rd Line is : selection.value = 1
Sub Sheets_Selection()
Sheet1.Select
Sheet2.Select False
Selection.Value = 123
End Sub