Key Points

• Use Help to find annotated lists of all the members for an object. Even if you’re not on-line, there is offline help available on your computer.

• Add new items to the ColorStops collection of a cells gradiant format to get multiple colors that are not available in the user interface.

• Take advantage of the Adjustments for shapes to multiply the number of available shapes available.

• When a shape contains grouped objects, you can use the GroupShapes collection to access the subordinate shapes without ungrouping and regrouping the shape.

• When the macro recorder doesn’t show you the methods and properties for an object, look at the user interface for clues.