title: Excel VBA assign hyperlink to a cell
body: <p>Currently I have VBA macro that will generate a page based on some information that I key into cell T3 on an overview page. What I would like to do is to have the same 'create page' button also automatically assign a hyperlink based on the value.</p>
  
  <p>For instance, if I put brownj1 into cell t3, a page will be created and named 'brownj1', what I would also like the macro to achieve is to assign cell 'b3' which also has the name 'brownj1' to the newly created page. Another way I think would probably be a better way around it would be to search/loop through column B to locate the matching cell to T3 and then assign the hyperlink.</p>
  
  <p>As I mentioned I already have the necessary code to generate the page and assign the name as the sheet name and all I am looking for is a formula to assign a hyperlink to a specific name as the page is being generated.</p>