In this code:
Dim Rng As Range
Set Rng = Sheet1.Range("A1:D4")
Dim RngElement As Range
For Each RngElement In Rng
RngElement.Value = 100
Next RngElement
it populates every cell in the range A1 to D4 with the value of 100.
I was of the understanding that the variable RngElement...