title: Include string and cell value in sheet name
body: <p>I have a simple workbook with sheets for 3 different websites I may buy things from.  I want to have the tab name update as I edit the worksheets.  The worksheet name would be website name + total of all items (cell C27)</p>
  
  <p>This is the macro as I have it:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Not Intersect(Target, Range("B27")) Is Nothing Then
          ActiveSheet.Name = "Amazon " + ActiveSheet.Range("B27")
      End If
  End Sub
  </code></pre>
  
  <p>I get the runtime error '13':
  Type mismatch</p>
  
  <p>I know this is because I'm combining 2 different types a string and a value, but I'm not too familiar with the syntax of VBA to be able to fix it.</p>
  
  <p>If I leave out the website name, it works perfectly.</p>
  
  <p>What is the easiest fix?</p>