Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Column | Excel Discussion (Misc queries) | |||
Loop Column letter A to Z ?? | Excel Programming | |||
loop through column to find value | Excel Programming | |||
Increment column in loop | Excel Programming | |||
HOW-TO? Loop through cells in a column | Excel Programming |