To understand the Range, cell funtion

[Ashish Batham]

With Range(Cells(reason_count + 18, 1), Cells(2 * reason_count + 17, 7))
.ClearContents
.Interior.Color = 16777215
End With
With Range(Cells(2 * reason_count + 38, 1), Cells(3 * reason_count + 37, 7))
.ClearContents
.Interior.Color = 16777215
End With
----------------------------------------------------------------------------

 

[Marc L]

​

To understand you must read VBA integrated help !​

​

 

[Hui]

Range() can be specified as:
Range("A1")
or
Range("A1:H5")
or
Range(Cells(2 * reason_count + 38, 1), Cells(3 * reason_count + 37, 7))
etc


in the last example Range will have a value from the cell at A (2 * reason_count + 38) to
G 3 * reason_count + 37

eg: if reason_count is 10
The Range will be A58:G67