title: Commas in 'Subaddress' of Hyperlink in Excel VBA
body: <p>I tried referring to a worksheet which has a 'comma' in its label for the 'Subadresss' property of the Hyperlink object in VBA Excel.</p>
  <p>Any idea how to get around this, rather than replacing the comma with other symbols?</p>
  <p>Example:
  My worksheet's name is : 1,1a</p>
  <p>Here is the code for the hyperlink:</p>
  <pre><code>Worksheets(&quot;Worksheet1&quot;)
          .Hyperlinks.Add Anchor:=.Range(&quot;c46&quot;), _
          Address:=&quot;&quot;, _
          SubAddress:=&quot;1,1a!A1&quot;
  </code></pre>
  <p>On clicking on such a hyperlink, I will get a 'Reference is not valid' error.</p>