What is the difference between Range.Columns and Range.EntireColumn

Posted by Laurent on Stack Overflow See other posts from Stack Overflow or by Laurent
Published on 2010-06-17T00:07:46Z Indexed on 2010/06/17 0:12 UTC
Read the original article Hit count: 219

Filed under:
|
Dim r as Range
Set r = Range("C2:D3")

Dim r1 as Range, r2 as Range
Set r1 = r.EntireColumn
Set r2 = r.Columns

Won't both ranges represent the range "C:D"? What is the difference between the two?

© Stack Overflow or respective owner

Related posts about excel

Related posts about vba