Range refers to a cell or block by address text, a defined name, or two corner cells. It is the workhorse object of nearly every macro.

Code

Range("A1:C10")
Range("Total")
Range("A1", "C10")

• By address

  Range("A1:C10") → A block by address

  The everyday form.

• By name

  Range("Total") → A named range

  Names survive layout changes.

• By corners

  Range("A1", "C10") Range(Cells(1, 1), Cells(10, 3)) → Two corners, useful with computed rows

  Build from variables.

• Qualify with a sheet: ws.Range("A1").
• Range("A1:A10").Value returns a 2D array; a single cell returns a value.
• Range("A:A") is a whole column; combine with End(xlUp) for the used part.

• Unqualified Range hits the active sheet.
• Range("A1:C10").Value = 5 fills every cell, which may be more than intended.