Hello.

I need to insert a hyperlink into excel using a macro to perform the insert-->hyperlink process rather than the hyperlink formula. The problem is that, from what I have found, I can't have the macro reference a cell that contains the web address. The web address must actually be spelled out in the VBA code. So, since this web address will change with each instance, I need to find a way to change the web address in the VBA code. I was thinking that I could use a macro to copy and paste the web address into the VBA code for this macro. However, my preliminary trials of this aren't working. I just wanted to save the time I would spend trying to figure out what is wrong by asking on this forum if this is even possible.

Thanks!