title: VBA Excel - Using a variable to determine cell location
body: <p>I don't exactly know how to formulate my question since so I'll just give an example which should make it clear.</p>
  
  <p>Basically I want to use a variable to determine what cell I have to use.
  For example, I count the amount of rows my sheet has and store it in a variable. Now I want to use that variable to determine a range.</p>
  
  <pre><code>Range("K2:M*").Select
  </code></pre>
  
  <p>Now where I have the * I want to use the rows I counted and stored in a variable earlier on.</p>
  
  <p>How can I do this?</p>