Practical Range Operations

Now THAT YOU UNDERSTAND the fundamentals of using a Range object—referring to ranges, navigating a worksheet using ranges and basic input/output —you can start learning how to do all of the things you'd do with a range if you were doing it (i.e., using the Excel interface) manually. In this chapter, you'll learn how to use the Range object to cut, copy, paste, filter, find and sort data in Excel.

This chapter, when combined with the previous chapter, is really the bread and butter of Excel development. After reading this chapter, if you're comfortable with all of the topics presented, I'll consider this book a success. Everything else is bonus material. Now that's value! Seriously though, most of what you do in Excel involves manipulating data, and to do that you use the Range object.

0 0

Post a comment