Hyperlink adding directory info??

I am using this code so every time I need to add a hyperlink I can add to a list easily and automatically. It used to work fine but now it adds the workbook directory to it. If I enter the website as "www.yahoo.com" I get an error when I try to click on the hyperlink because it shows to be linked to "File:///G:\New Folder\www.yahoo.com" When I try to edit hyperlink it shows "Existing File Or Web site is clicked,and address is "www.yahoo.com"???? What am I doing wrong?

Please Login or Register  to view this content.

Please help this is driving me crazy!!!

Thank you in advance

UPDATE: I figured it out.... turns out I MUST enter HTTP:// first. Sorry and thank you.

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Also, in future, it will be good if you post the solution in a separate post (post 2) of your thread. This way, others reading it can quickly distinguish between the question and the solution.