title: Excel vba create a hyperlink
body: <p>I'm trying to create a hyperlink with vba.  I have a macro that extracts a report name (string) and report ID (string) from a website.  These 2 pieces of info are written to the 'Results' sheet in Excel.  So far, so good.  </p>
  
  <p>The next step is to create a hyperlink in the 3rd column that appears to be the Report Name.  However, the URL for the hyperlink is <a href="https://PeopleSoft/psreports/prd/" rel="nofollow noreferrer">https://PeopleSoft/psreports/prd/</a> and the Report ID.  It would look like this:
  <a href="https://PeopleSoft/psreports/prd/123456" rel="nofollow noreferrer">https://PeopleSoft/psreports/prd/123456</a>.  </p>
  
  <p>I can put the URL together.  However, what I'm trying to do is create a hyperlink in the 3rd column and looks like the report name in the first column.</p>
  
  <p>I'm having trouble getting the report name and URL together to create the hyperlink.  Is this possible?  Any help would be greatly appreaciated.......</p>