When is it necessary to loop over the cells in a range as opposed to setting
some property of the entire range at once. For example:

Sub loop_test()
Dim rr As Range, r As Range
Set rr = Range("A1,C10,D12")
For Each r In rr
r.Value = r.Address
Next
End Sub


can be accomplished with:

Sub loop_test2()
Dim rr As Range
Set rr = Range("A1,C10,D12")
rr.Value = rr.Address
End Sub
--
Gary''s Student - gsnu200747