CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 7 of 7

Threaded View

  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Simple Code - Help

    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
    Last edited by Frlecube; August 4th, 2009 at 02:31 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured