R
Ron
Help please for adding hyperlinks with a macro.
The result of a macro recording session using only one cell AI is
below
Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"2004/Backups/040110.xls", TextToDisplay:= _
"Lusc....... "
How can I hyperlink multiple cells beginning in A1 and then in every
odd row number in Col A?
eg.
A
1. Lusc...
2. Occu..
3. Boun...
4. Savo...
5. Pana...
6. Sail...
The total number of rows varies each time the macro runs.
TIA
Ron
The result of a macro recording session using only one cell AI is
below
Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"2004/Backups/040110.xls", TextToDisplay:= _
"Lusc....... "
How can I hyperlink multiple cells beginning in A1 and then in every
odd row number in Col A?
eg.
A
1. Lusc...
2. Occu..
3. Boun...
4. Savo...
5. Pana...
6. Sail...
The total number of rows varies each time the macro runs.
TIA
Ron