Hyperlink.add Anchor with .Cells instead of .Range
<p>I have some code that doesn't seem to be working shown below</p>

<pre><code>With Cells(emptyRow, 13)
     .Hyperlinks.Add Anchor:=.Cells(emptyRow, 13), _
     Address:=EmailLinkTextBox.Value, TextToDisplay:="Link"
End With
</code></pre>

<p>and I believe it is due to the anchor because I found that the description for anchor stated it can be either a Range or Shape object.</p>

<p>Is this the issue, if so is there anyway to make it work?</p>

<p>Thank You</p>