title: Extract a Range Value and assign to a String Variable
body: <p>I would like to extract a range value and assign it to a string variable.</p>
  
  <p>In the following image, the value that I would like to store to a string variable is from <code>Range("E10:J11").Value(1,1)</code> which holds the string "Disputes/Appeals".</p>
  
  <p><a href="http://i.stack.imgur.com/wT5Hd.png" rel="nofollow">Range values</a></p>
  
  <p>The codes that I used for implementation are:</p>
  
  <pre><code>Dim P3 As String
  
  'This line gives me Run-time error '13'
  'Type mismatch
  P3 = Worksheets("NameofmySheet").Range("E10:J11").Value
  </code></pre>
  
  <p>Having this error, I knew that I need to be specific to the arguments of <code>.Value</code> so that my assignments would agree to the same data type.</p>
  
  <p>Based from the image, following the <code>Range("E10:J11").Value(1,1)</code> specification, here is what I did:</p>
  
  <pre><code>'This line gives me Run-Time error '450'
  'Wrong number of arguments or invalid property assignment
  P3 = Worksheets("NameofmySheet").Range("E10:J11").Value(1, 1)
  </code></pre>
  
  <p>Now I think I am on the right track but I could just not find out the correct syntax or the proper arguments for this type of assignment.</p>