title: Macro Hyper links in Excel
body: <p>I have this code that changes a cell into a hyper link. I want to use the value of the cell in the hyperlink</p>
  
  <pre><code>Sub HyperAdd()
  
  'Converts each text hyperlink selected into a working hyperlink
  
  For Each xCell In Selection
  
  
      ActiveSheet.Hyperlinks.Add Anchor:=xCell, _
      Address:="http://example.ie/booking/viewBooking/=xCell"
  
  Next xCell
  
  End Sub
  </code></pre>
  
  <p>if the cell value is 123 how do i make the anchor link this url <a href="http://example.ie/booking/viewBooking/123" rel="nofollow">http://example.ie/booking/viewBooking/123</a></p>