Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
script to increase last number in cell entry for hyperlink
Hi
I have an excel sheet with 4,000 rows each having a record of a picture. I need to hyperlink a cell entry in each row to open the picture when it is clicked. I can do this through insert hyperlink command but don't want to do it 4,000 times! Is there a way to do this with vba? Either from a macro button or running a script that would increment the file name by 1 digit for each row i.e. Filepathpicture1 (set by hyperlink) filepathpicture2 filepathpicture3 and so on with the script changing the picture number. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
script to hyperlink and reference a cell value in the hyperlink | Excel Programming | |||
How do I turn a VBA script on and off with an entry in a cell | Excel Programming | |||
how to increase the number by 1 from the cell above? | Excel Worksheet Functions | |||
Script to add hyperlink to Excel cell containing text | Excel Programming |