Cells and Ranges

Cells and Ranges

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

This topic links to programming tasks (how-to and walkthrough topics) for common cells and ranges scenarios.

"How Do I ..." is your gateway to key task-based topics about programming and application development using Excel. The links provide pointers to important, procedure-based help topics.

Create an HTML File with a Table of Contents based on Cell Data

Describes how to take data from a worksheet and create a table of contents in an HTML file.

Delete Duplicate Entries in a Range

Describes how to delete duplicate entries in a range.

Fill a Value Down into Blank Cells in a Column

Describes how to fill a value down into blank cells.

Hide and Unhide Columns

Describes how to find all the cells that contain a certain value and hide or unhide the columns that contain that value.

Highlight the Active Cell, Row, or Column

Describes how to highlight the active cell, or column with a color.

Make a Cell Blink

Describes how to make a cell blink by changing the color of the cell.

Prevent Duplicate Entries in a Range

Describes how to prevent duplicate entries of a value in a given range.

How to: Reference Cells and Ranges

Describes how to reference cells and ranges in order to do enter formulas or change formats.

How to: Refer to All the Cells on the Worksheet

Describes how to refer to all cells on a worksheet.

How to: Refer to Cells and Ranges by Using A1 Notation

Describes how to refer to cells and ranges by using A1 notation.

How to: Refer to Cells by Using a Range Object

Describes how to refer to cells by using a Range object.

How to: Refer to Cells by Using Index Numbers

Describes how to refer to cells by using index numbers.

How to: Refer to Cells by Using Shortcut Notation

Describes how to refer to cells by using shortcut notation.

How to: Refer to Cells Relative to Other Cells

Describes how to refer to cells relative to other cells.

How to: Refer to Multiple Ranges

Describes how to refer to multiple ranges.

How to: Refer to Named Ranges

Describes how to refer to named ranges.

How to: Refer to Rows and Columns

Describes how to refer to rows and columns in Excel.

Select a Range

Describes how to select the used range and the data range on a worksheet.

Show:
© 2016 Microsoft