title: VBA error in Excel: Invalid Use of Property
body: <p>I have written the below code in <code>CommandButton_Click()</code>, but it gives the following error:</p>
  
  <blockquote>
    <p>Compile Error:Invalid Use of Property.</p>
  </blockquote>
  
  <pre><code>Public Sub SectorNAme()
    Dim score As String, result As Integer
    Dim a_counter As Integer
  
    For a_counter = 1 To 473
      score = Range("AB" + a_counter).Value
  
      If score = "Technology &amp; FM" Then
        result = "25"
      ElseIf score = "Operating Equipment &amp; Supplies" Then
        result = "26"
      ElseIf score = "Interiors &amp; Design" Then
        result = "27"
      ElseIf score = "Outdoor &amp; Resort Experience" Then
        result = "28"
      ElseIf score = "HORECA" Then
        result = "29"
      ElseIf score = "Retail &amp; Franchise" Then
        result = "30"
      ElseIf score = "Design" Then
        result = "33"
      ElseIf score = "Health &amp; Fitness Eqpts, P&amp;S" Then
        result = "32"
      ElseIf score = "Recreational Fun &amp; Adventure" Then
        result = "31"
      Else
        result = "35"
  
      Range("AC" + a_counter).Value
  
      End If
    Next a_counter
  End Sub
  </code></pre>
  
  <p>Please help me find a solution.</p>