Some Useful Range Object Properties

A Range object has dozens of properties. You can write Excel programs nonstop for the next 40 years and never use them all. In this section, I briefly describe some of the more commonly used Range properties. For complete details, consult the Help system in the VBE.

Some Range properties are read-only properties, which means you can't change them. For example, every Range object has an Address property (which holds the range's address). You can access this read-only property, but you can't change it.

The examples that follow are typically statements rather than complete procedures. If you'd like to try any of these (which you should), create a Sub procedure to do so. Also, many of these statements work properly only if a worksheet is the active sheet.

0 0

Post a comment