I Need a simple script like this one to do this in excel .... but with a loop or something from row 17 to row 100 and i dont want to repeat the same line 80 times. I know its simple but i dont know : (
Code:Sub Macro1() Range("H17").Select Selection.Hyperlinks.Add Anchor:=Selection, Address:=Range("AZ17") Range("H18").Select Selection.Hyperlinks.Add Anchor:=Selection, Address:=Range("AZ18") Range("H19").Select Selection.Hyperlinks.Add Anchor:=Selection, Address:=Range("AZ19") End Sub
Thanks !!!!!!
Regards
Francisco





Reply With Quote
