From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Manage workbook elements and data in VBA

Solution: Manage workbook elements and data in VBA - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Solution: Manage workbook elements and data in VBA

“

(upbeat music) - [Instructor] In the previous movie, I gave you three challenges on working with data in an Excel workbook, and in this movie, I will go through my solutions to those problems. My sample file is 05_10_Solution, and you can find it in the Chapter Five folder of the Exercise Files collection. So I have two worksheets, January and February, and we need to work with them individually. So I will press Alt+F11 to move to the Visual Basic Editor, and here, in the first subroutine write value, I was asking you to replace this property name with the code that you needed to write a value, and that is value. So this code will write the value January to cell B4 on the January worksheet. And if I press Alt+F11 to move back, and then move to January, you can see that B4 is currently blank. So Alt+F11 to move back, and then insertion point's blinking there. So F5, it runs. Alt+F11 again, and you can see the…

Contents