VB Code for hyperlink

[Duane Reynolds]

Morning
I have been linking cells to webpages in a round about way. It works but I
know there has to be a better way in VB without all the extra columns and
formulas. currently I have a base address that I then CONCATENATE with a
permit number and tab #. I end up using 3 columns to create my hyperlink.
The formulas look like this

'http://web1.seattle.gov/DPD/permitstatus/Project.aspx?id=
'=CONCATENATE(aphttp,E12,"&t=2")
'http://web1.seattle.gov/DPD/permitstatus/Project.aspx?id=6178468&t=2
'=HYPERLINK(C13,E13)

I would like to run a macro that loops thru the column with permit numbers
and convert into hyperlinks to the permit status page.
Thanks
Duane Reynolds

 

[Duane Reynolds]

Morning
I have been linking cells to webpages in a round about way. It works but I
know there has to be a better way in VB without all the extra columns and
formulas. currently I have a base address that I then CONCATENATE with a
permit number and tab #. I end up using 3 columns to create my hyperlink.
The formulas look like this