Creating hyperlinks in VBA

Further to my previous thread, I now need the cells created to be hyperlinks; i.e. now, instead of "http://..." appearing, the same word as was typed (e.g. "Physics") should appear which, when clicked on, leads one to the right website. The line I added to the example I was given is repeated again below (and is also, inevitably, the only line that does not work ).

Thanks in advance!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Thanks, that does work, but it now adds hyperlinks to the column where I'm typing (i.e. Column E); I want it to add the words and hyperlinks to the other column (Column G), even though it says "1Y_Col".

Any ideas?

Column G is offset by 2 columns from column E, so it will be:

Please Login or Register  to view this content.

see your original thread Here

TYVM everyone