Some Useful Range Object Properties

s ri

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 that you can look at their values, but 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