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, and use the Object Browser to learn about objects, properties, and methods.
View Complete Post