Thanks Guys. I'm confident what you put here with the Dim statement will
work but as I've never actually programmed in Excel I'm kind of lost here as
to what to do with this. Any pointers/tips?

"Sandusky" wrote:


"Big UT Fan" wrote in message
...
I'd like to take the values (numbers) in a particular column to a
hyperlink
in which the number is part of the url. For example, imagine a col of 5
digit #s. In cell A:2 is 12345. I want to change this to a hyperlink to
the
url http://www.url.com/id=12345. There has to be a way but I've never done
it. Thanks!

Dim tx as String
tx = "http://www.url.com/id=" & Range("A2").Value