title: how to get unlimited range in vba
body: <pre><code>Dim Brand As String
      Worksheets("1st").Select
      Brand = Range()
  </code></pre>
  
  <p>Hi, I am using VBA coding in microsoft excel 2011 and I am a little stuck with range. Lets say I want to start something in cell c4, I enter in c4 in the range but if I then want it to continue till all the way down the column (unlimited as we don't know how many rows in that column will be filled up), then what is the correct way of writing this?</p>