What does this code do?

[gheyman]

Range(Cells(6, 1), Cells(200, 4)).ClearContents

I understand its clearing contents. I don't understand the Range/Cells

 

[dreid1011]

Range can be typed in two different ways. The first is:

Range("A2")
Range("A2:D5")

The second is:

Range(Cells(2, 1))
Range(Cells(2, 1), Cells(5, 4))

Where each Cells() is identifying one specific cell. I believe it is Cells(row, column), so:

Range(Cells(2, 1), Cells(5, 4)) = Range("A2:D5")

 

[Scott T]

Cells(Row,Column)

Since the first column is A and the 4th column is D
so the code clears the contents of the range A6:D200