Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
hello and world need to be in quotes unless they're numbers. use an ampersand (&) to join text strings together and join them with other things. Ex: myvar1 = "Hello " myvar2 = "World!" Range("A1") = myvar1 & myvar2 Great question! Thanks for stopping by Gareth!! Dan
Hi Dan, I was wondering if you could teach me how to write 2 variables into a cell? For example, myvar1 = hello , myvar2= world and i want cell A1 to become hello world. How do I do this? Is it Range("A1").value = myvar1 + myvar2?
Great content. Thank you much for the lessons. I've tried the code and I am getting incorrect output on B2 cell. All other output is correct. Loop - First iteration(B2 cell) = 1/30/1900. The date is being placed in the B2 cell and I don't understand why. Is anyone else getting these errors? Help on debugging and understanding why this the case would be appreciated. Thanks.
Hey bro I have a question. How would we make it apply to the workbook, but ALL sheets within it instead of only those listed in the ("SheetName") command that follows the "ThisWorkBook.Sheets...." line
Hi , I was this code "ThisWorkbook.Sheets(" My Report").Cells(1, 1) = 10" while running i am getting an error "subscrption out of range". I don't understand why please help
Hey, So I am trying to write a VBA code to delete rows when two certain columns have values "(Blank)", "-", or "0" in both columns. I am also trying to use a command button to do this, but I can not figure out how to write the code. I need the help of an expert such as yourself. The deleting of rows depends on if columns E and F both have either "()", "-", or "0" in both of the spaces. Could you perhaps make a video showing how to delete rows if two columns have those specific features. Other videos I have looked at that try to explain it are not clear enough and have a lot of confused people commenting. You are good at teaching this and I was wondering if you could do a video on it. Thank You
Yes, Mohammad, you can apply code and extract data even if its very hidden. There are three options with the visible property. xlSheetVisible, xlSheetHidden or xlSheetVeryHidden. But instead of the first two I prefer using true or false cause it still works. Example, you want sheet calle myRpt1 to be very hidden thisworkbook.sheets("myRpt1").visible = xlSheetVeryHidden Blessings, Dan
I get the following error when I run the command for selecting the sheet: "Run-time Error '1004': Unable to set the Select property of the Worksheet Class". Can you please help me with this.
Dan, Thank You so much for replying. This is the code that I used. I think I copied it straight from what was explained in the video. I am working with Excel 2013 and had created another sheet before running this code: Sub UnhideMyReport() ThisWorkbook.Sheets("My Report").Visible = True ThisWorkbook.Sheets("My Report").Select = True End Sub
The .SELECT method is a Method, so it doesn't need to be true or false, it's like a command you run. So you'd want to just say "Hey, select that sheet", rather than "That sheet being selected is true". Try this: Sub UnhideMyReport() ThisWorkbook.Sheets("My Report").Visible = True ThisWorkbook.Sheets("My Report").Select End Sub
Thank you for sharing your knowladge. You have enriched a lot of people with it.
I have lean't great things from Excel is Fun TH-cam videos and learning/revising VBA from VBA is Fun videos. Thanks Bro!! God Bless!!
Very simple, yet very good content on Excel VBA and Macros. Very nice videos and appreciate for sharing these.
I'm really glad you've been learning so much! Thanks for the comments, Saroj!! Keep it up! Dan
Loving this series - easy to follow and play along which reinforces my learning. AWESOME Daniel Thank you
Yesterday I've starded watching your videos and I couldn't imagine that learnig VBA code is so simple :) Thanks for your hard work, Dan! :)
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
thank you buddy, you are really great. I am new in programming, but your classes are quite understandable. all the best... keep going
You're very welcome. I'm glad this helps, jagadish.
Great Video!
Thank you , Sir! Very helpful videos, appreciate it
Thanks for sharing your knowledge. It is very useful
You're very welcome, Johannes! Thanks for the nice comment and please keep sharing and clicking "Like" if you would. :)
that was really helpful ,thank you for sharing your knowlegde
Thank you. God bless you much as well. You are a blessing.
hello and world need to be in quotes unless they're numbers.
use an ampersand (&) to join text strings together and join them with other things.
Ex:
myvar1 = "Hello "
myvar2 = "World!"
Range("A1") = myvar1 & myvar2
Great question! Thanks for stopping by Gareth!! Dan
7:21 SHAZAM!
You are awesome !!!! Many thanks
Thanks Clifford! Much appreciated! Dan
Very welcome Gareth! Dan
thank you so much for your great help
This is awesome! Thanks!
Thanks Otavio! So glad you like!
Great videos, in sheet 1, you type your data, your data is in sheet 3, which is hidden. can i create a vba code to pull data from a hidden sheet?
Great job !
Thanks Dawid Kruszyński
Hi Dan, I was wondering if you could teach me how to write 2 variables into a cell? For example, myvar1 = hello , myvar2= world and i want cell A1 to become hello world.
How do I do this? Is it Range("A1").value = myvar1 + myvar2?
Very welcome, 5adamjb! Thank you!
Great content. Thank you much for the lessons.
I've tried the code and I am getting incorrect output on B2 cell. All other output is correct.
Loop - First iteration(B2 cell) = 1/30/1900.
The date is being placed in the B2 cell and I don't understand why. Is anyone else getting these errors?
Help on debugging and understanding why this the case would be appreciated. Thanks.
You're very welcome! Thanks sir. DAn
Hello First of all great job. Can you use the name of the workbook instead of use thisworkbook. ?
Very helpful.
Hey bro I have a question. How would we make it apply to the workbook, but ALL sheets within it instead of only those listed in the ("SheetName") command that follows the "ThisWorkBook.Sheets...." line
Hi , I was this code "ThisWorkbook.Sheets(" My Report").Cells(1, 1) = 10" while running i am getting an error "subscrption out of range". I don't understand why please help
Hey, So I am trying to write a VBA code to delete rows when two certain columns have values "(Blank)", "-", or "0" in both columns. I am also trying to use a command button to do this, but I can not figure out how to write the code. I need the help of an expert such as yourself. The deleting of rows depends on if columns E and F both have either "()", "-", or "0" in both of the spaces. Could you perhaps make a video showing how to delete rows if two columns have those specific features. Other videos I have looked at that try to explain it are not clear enough and have a lot of confused people commenting. You are good at teaching this and I was wondering if you could do a video on it.
Thank You
hey im getting error 9 when I use this what is the problem with my code?
May I see your code, monta1994? Thanks! Dan
How to make a sheet Very hidden using VBA?
and can we apply code to it or extract data from it while it's very hidden?
Yes, Mohammad, you can apply code and extract data even if its very hidden. There are three options with the visible property. xlSheetVisible, xlSheetHidden or xlSheetVeryHidden. But instead of the first two I prefer using true or false cause it still works.
Example, you want sheet calle myRpt1 to be very hidden
thisworkbook.sheets("myRpt1").visible = xlSheetVeryHidden
Blessings,
Dan
Thank you verymuch Dan
Mohammad Taha You're absolutely welcome!
Where is Excel VBA Basics #6? I can't find it
I get the following error when I run the command for selecting the sheet: "Run-time Error '1004': Unable to set the Select property of the Worksheet Class". Can you please help me with this.
Hi Vikramjeet,
Can you show us the code you used so we can better assist?
Thanks
Dan
Dan,
Thank You so much for replying. This is the code that I used. I think I copied it straight from what was explained in the video. I am working with Excel 2013 and had created another sheet before running this code:
Sub UnhideMyReport()
ThisWorkbook.Sheets("My Report").Visible = True
ThisWorkbook.Sheets("My Report").Select = True
End Sub
The .SELECT method is a Method, so it doesn't need to be true or false, it's like a command you run. So you'd want to just say "Hey, select that sheet", rather than "That sheet being selected is true". Try this:
Sub UnhideMyReport()
ThisWorkbook.Sheets("My Report").Visible = True
ThisWorkbook.Sheets("My Report").Select
End Sub
Thank You so much Dan!
Vikramjeet Singh you are most welcome, Vikramjeet!
Thanks!
Thx a lot man
thank you so much
nhựt lê văn You're very welcome!
very welcome!
Great
not very fun, but helpful