Range Object

VBA works with many Microsoft products, not just Excel. But most VBA applications are Excel specific and VBA's tight integration with Excel gives it unique advantages. One advantage is VBA can manipulate Excel's cells.

Excel has this thing we call a cell. Cells can store text, numbers, formulas and images. Cells can be linked to create complex calculation chains, or grouped to create lists and data tables. Cells are range objects and the base unit in any Excel project. They are the thing that VBA probably manipulates most in Excel projects; thus, learning how to work with range objects is fundamental to most VBA applications.

This section's subpages explore various aspects of ranges that are commonly used in VBA projects. Click links at right to learn more