Other Ways to Refer to a Range

The more you work with VBA, the more you realize that it's a fairly well-conceived language and is usually quite logical (despite what you may be thinking right now). Often, VBA provides multiple ways of performing an action. You can choose the most appropriate method for your problem. This section discusses some of the other ways to refer to a range.

This chapter barely scratches the surface for the Range object's properties and methods. As you work with VBA you'll probably need to access other properties and methods. The Help system is the best place to find out about them, but it's also helpful to simply record your actions and examine the code Excel generates.

0 0

Post a comment