From the course: Excel: Learning VBA

Unlock the full course today

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

Challenge: Manage workbook elements and data in VBA

Challenge: 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

Challenge: Manage workbook elements and data in VBA

“

(upbeat music) - [Narrator] Now that we have reached the end of the chapter, I wanted to give you a series of three challenges about managing workbook elements and data. So the challenges are to write a value to a cell, to copy and paste data, and to refer to cells using the offset property. As with the other challenges of this course, I'll ask you to prepare by reading the comments in each code module, and then to create your solution either by adding to or editing the existing code. And finally, to run your code to make sure it works. Now, let's switch over to the workbook that you'll use, and you can see what I have set up for you. The workbook I created for you is 05_09_ChallengeIntro, and you can find it in the chapter five folder of the exercise files collection. I have two worksheets, January and February, and you'll perform different operations on those two worksheets. To see the code that you'll be working…

Contents