Include string and cell value in sheet name
<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>