title: Syntax to Define an Entire Row as Range
body: <p>In Excel, I can define an <strong>entire column</strong> as a range and address individual cells in that range like:</p>
  
  <pre><code>Sub headache()
     Dim r As Range
     Set r = Range("A:A")
     MsgBox r(1).Address &amp; vbCrLf &amp; r(2).Address
  End Sub
  </code></pre>
  
  <p>If I try to do the same thing with an <strong>entire row</strong>:</p>
  
  <pre><code>Sub headache2()
     Dim r As Range
     Set r = Rows(1)
     MsgBox r(1).Address &amp; vbCrLf &amp; r(2).Address
  End Sub
  </code></pre>
  
  <p>I do not get the individual cells in the range.  My workaround is:</p>
  
  <pre><code>Set r = Range(Cells(1, 1), Cells(1, Columns.Count))
  </code></pre>
  
  <p>I can't believe this is the simplest way to make the range...........any suggestions??</p>