Hyperlink created from cell content

**Endorphin** · 10-21-2008, 03:26 AM

Good Morning all,

Is there a way to automatically create a Hyperlink from the content of a cell for that cell.

ok, Cell A1 has the number 883908 in it, I am after a way to automatically get that number to create its own hyperlink to go to say :
"www.google.co.uk/883908"

Is this at all possible?

Neil

**royUK** · 10-21-2008, 03:53 AM

Try this

Const sWeb As String = "http://www.google.co.uk/"
 ActiveWorkbook.FollowHyperlink Address:=sWeb & ActiveCell.Value

**Endorphin** · 10-21-2008, 04:06 AM

Hi Roy,

Sorry, dont think I made it very clear.

There will be a costantly added to list as well as other information on this page.
When a new number is added to the column, can that number be turned into a hyperlink as above automatically or via running a macro. It does not need to open automatically, just when clicked on.
Neil