Add hyperlink to the text in a cell

[saidineshbabu]

Hi,

I have a common URL which needs to be added to the cell and show as hyperlink. Clicking the link to go to the correct page.

eg: http://www.google.com/ is the URL

cell 1 has a text "mail"

It should be mapped to the hyperlink "http://www.google.com/mail" and show as hyperlinked text.

Thanks in advance.

[Norie]

You could use the HYPERLINK worksheet function.

Please Login or Register  to view this content.

[saidineshbabu]

Great thanks. I want this to be automated through macro. I am not good in macro. can you pls help?