Excel VBA Basics #7 - Using specific sheets, Hiding, Unhiding and Selecting with VBA

We'll even show you how to read and write on a HIDDEN worksheet. We also show how to programmatically hide or unhide a worksheet using VBA and selecting whatever sheet to be viewed.

Fantastic Developer Tools:

[ExcelVbaIsFun]

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

[ExcelVbaIsFun]

I'm really glad you've been learning so much! Thanks for the comments, Saroj!! Keep it up! Dan

[cliffordhammond]

Thank you for sharing your knowladge. You have enriched a lot of people with it.

[tinapalmer]

Loving this series - easy to follow and play along which reinforces my learning. AWESOME Daniel Thank you

[maciejmyslinski]

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! :)

[namdeoamit]

Very simple, yet very good content on Excel VBA and Macros. Very nice videos and appreciate for sharing these.

[sarojnayak]

I have lean't great things from Excel is Fun Youtube videos and learning/revising VBA from VBA is Fun videos. Thanks Bro!! God Bless!!

[malakaranvigin]

thank you buddy, you are really great. I am new in programming, but your classes are quite understandable. all the best... keep going

[ExcelVbaIsFun]

You're very welcome. I'm glad this helps, jagadish.

[ExcelVbaIsFun]

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

[arulamaldoss]

Thank you. God bless you much as well. You are a blessing.

[ExcelVbaIsFun]

Thanks Clifford! Much appreciated! Dan

[MCA]

Thanks for sharing your knowledge. It is very useful

[diao]

Thank you, Sir! Very helpful videos, appreciate it

[ExcelVbaIsFun]

You're very welcome! Thanks sir. DAn

[BDQUERY]

that was really helpful, thank you for sharing your knowlegde

[johnwatkins]

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?

[iliasgiannenakis]

Hello First of all great job. Can you use the name of the workbook instead of use thisworkbook. ?

[esquilaxk]

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.

[diao]

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?