Worksheet.Range (Excel)

The Range property of the Worksheet object returns a Range object that represents a cell or a range of cells.

Often, Cell1 and Cell2 are single cells in the upper-left and lower-right corners of the range returned (see image). Cell1 and Cell2 can be Range objects that contain a single cell, column, row, or any other range of cells.

Cell1 and Cell2 can be A1-style references. The range references can include the range operator (a colon), intersection operator (a space), or union operator (a comma). They can also include dollar signs, which are ignored. A local defined name can be a range reference.

Range (Cell1, Cell2)

Worksheets("Sheet1").Range("A1").Value = 3.14159
Builder to make Range

The dialog is part of the Code VBA add-in and guides the user in filling the procedures arguments.

Arguments

The following argument is required

Cell1 (Range) - A String that is a range reference when one argument is used. Either a String that is a range reference or a Range object when two arguments are used.

Optional arguments

The following argument is optional

Cell2 (Range) - Either a String that is a range reference or a Range object. Cell2 defines another extremity of the range returned by the property.

ActiveSheet Range menu

Accessing the Range dialog from the Code VBA menu