title: VBA use string for range
body: <p>I need help for my VBA tool.</p>
  
  <p>In my program I define a string keyword:</p>
  
  <pre><code>    Public Sub SetKeyword()
  
          Call Define_Variables.variables
          Call Database.Allocation
  
          strKeyword="KINDACC"
  </code></pre>
  
  <p>Now I would like to set the name of the range keyword with my string keyword, so it looks like this:</p>
  
  <pre><code>    Public Sub SetKeyword()
  
  
          Call Define_Variables.variables
          Call Database.Allocation
  
  
          strKeyword="KINDACC"
          rngKeyword= r_KINDACC
  
       End Sub
  </code></pre>
  
  <p>In my module "Database" I have those r_strKeywords already defined:</p>
  
  <pre><code>    Sub Allocation()
  
  
      'General accident information
       ...
       Set r_KINDACC = Worksheets("Database").Range("N4:N14")
       End sub
  </code></pre>
  
  <p>So later with my GUI I would like to define a string-keyword and my program automatically defines my range-keyword with my string keyword:</p>
  
  <pre><code>     Public Sub SetKeyword()
  
  
            Call Define_Variables.variables
            Call Database.Allocation
  
  
            strKeyword=blabla
            rngKeyword= r_strKeyword
  
      End Sub
  </code></pre>
  
  <p>Is that possible?
  I hope it's not too confusing</p>
  
  <p>thanks!!</p>
  
  <p>Viktoria</p>