Chapter 4. Explore Range Objects

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Use several properties to refer to Range objects from macro statements.

  • Put values and formulas into cells.

  • Simplify macros that record selections.

  • Apply formatting to ranges.

  • Use the Object Browser to learn about objects, properties, and methods.

The world would be much simpler if people were all the same size. You wouldn’t need adjustable seats in your car; your head would never get bumped on a door frame; your feet would never dangle from a chair. Of course, you’d have new problems as well: When you went to exchange that hideous outfit you got for your birthday, ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.