The reference to the range is generated based on its two corner cells:
–Start cell: The upper-left corner of the range.
–End cell: The lower-right corner of the range.
The start and end cells are separated by the colon “:” operator. For example, B4:D6.
If the R1C1 style is selected for cell addressing, in some cases it is not necessary to specify the : range operator. Thus, to obtain a reference to the range of all cells in a single row, you can only specify a reference to that row. For example, R1 reference refers to the range of all cells in the first row.