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?
From Iraq - Thank you very much for your kind efforts
Thank you...Finally!! VBA Course with applicable examples. Your explanation is concise and your teaching is preemptive.
This course playlist is the most useful tutorial I have found. It has become my 'bible'.
You are a born teacher. You have a flair for teaching in easy & simple way. Keep it up
Thanks brother.... very helpfull ...post More VBA videos
Sumit bro..i watch your video every day
Very nice explanation. Thank you.
nicely explained
Thanks so much.
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
Very useful! Thanks
Thank you so much...
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.
Can we copy from excel and paste in outlook email??
great
can we give print command to sheet B specific content (which is hidden) from sheet A
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 ?
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
why when you specify a single cell range it copied whole content in the work sheet