Peter wrote:
.. . .
What does range.Columns return? Is it a collection (of what). . . .

Range("A1:D10").Columns.Address returns $A$1:$D$10. It is a collection
of columns; i.e., Range("A1:D10").Columns(2).Address returns $B$1:$B$10;
Range("A1:D10").Columns(2)(2) returns $C$1:$C$10;
Range("A1:D10").Columns(2).Cells(2) returns $B$2.

Alan Beban