VB Code for hyperlink
 

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

VB Code for hyperlink clarification
 

"Duane Reynolds" wrote in message
...
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


' This is stored as named range "aphttp"
http://web1.seattle.gov/DPD/permitst...oject.aspx?id=
'=CONCATENATE(aphttp,E12,"&t=2") returns
'http://web1.seattle.gov/DPD/permitstatus/Project.aspx?id=6178468&t=2
'Which I then use with =HYPERLINK(C13,E13) to create friendly name using
the permit number

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