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" 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