Loop through Column and add hyperlink
 

I'd just use another column of cells and the =hyperlink() worksheet function:

=hyperlink("http://www.whatever.com/" & a2,"Click me")

or something like this.

wrote:

Hi,

I am terribly bad with loops and was hoping someone could help me with
some code.

I have column A, called Item. It has numbers in it.

ex:
Item
123
124
234
223

I need to loop through all the non blank cells in the column and add a
hyperlink to each item number. They hyperlink would be something like
http:....123. The ticket number would be at the end. The main part of
the hyperlink excluding the ticket number is always the same.

Thanks for anyone who can assist.

--

Dave Peterson

Loop through Column and add hyperlink
 

yes, that would make sense from the question I asked. There was
actually another part that I left out. When you drill down into a pivot
table and a new sheet is created, I was putting this code in the
newsheet event because it loses the hyperlinks otherwise. Thanks for
you idea too..