Reference Sequential cells

[billandrew]

Evening All

Could someone provide a bit of explanation to the reference below.



Range(Cells(2, "D"), Cells(2, "F")).Cells(1) = "A"
Range(Cells(2, "D"), Cells(2, "F")).Cells(2) = "B"
Range(Cells(2, "D"), Cells(2, "F")).Cells(3) = "C"

Thnks

 

[uzaname]

The lines refer to D2, E2 and F2, respectively. The "Cells(1)" on the end is saying to select the first cell from the the range object: "Range(Cells(2, "D"), Cells(2, "F"))", which refers to [D2:F2]. "Cells(2)" says to select the second cell, E2. Given that there are no variables involved, a more intuitive way to write it would be something like:

[D2:F2].value = Array("A","B","C")

 

[Tetra201]

Range(Cells(2, "D"), Cells(2, "F")).Cells(1) is the first cell in range D2:F2, that is, cell D2.

 

[uzaname]

Cells(1) refers to [A1]
Cells(2) refers to [B1]
Cells(1,2) refers to [B1]
[B2] refers to [B2]
Range("B2") refers to [B2]
Range(Range("B2").Address) refers to [B2]
Columns(2).Cells(2) refers to [B2]
Cells(1).Offset(1,1) refers to [B2]
Cells(2,"B").Offset(1,1).Resize(2,3) refers to [C3:E4]
Union([B2],Cells(1),Range("A4")).Cells(2) refers to [B3]

 

[billandrew]

Thanks to both much appreciated