+ Reply to Thread
Results 1 to 5 of 5

run vba till end of column

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    run vba till end of column

    hello friends ,
    i am new to marco
    if anybody here can help me with ......


    i want to run below marco till B54001

    Sub ClickMe()
    urladd = Range("B1")
    Sheets(1).Hyperlinks.Add Range("A1"), urladd, "", "URL Len: " & Len(urladd), "ClickMe"
    End Sub

    problem is , it has two columns to be mention .

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: run vba till end of column

    sub ClickMe()
    dim I
    for I = 1 to 54001
    Sheets(1).hyperlinks.add Range("A" & count), Range("B" & count), "", "URL Len: " & Len(Range("B" & count)), "ClickMe"
    next I
    end sub

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: run vba till end of column

    @ ragulduy's code modified

    Please Login or Register  to view this content.
    Last edited by satputenandkumar0; 08-12-2014 at 05:49 AM.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.

  4. #4
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: run vba till end of column

    hi , ragulduy and satputenandkumar0

    its working perfectly

    thanks
    Last edited by raj soni; 08-12-2014 at 05:52 AM.

  5. #5
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: run vba till end of column

    It was ragulduy's code.

    Thanks ragulduy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  2. Copy entire selected column to next columns till last column
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 05:20 AM
  3. [SOLVED] Identify the last filled row in Column A and then drag formula in Column B till the same
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2012, 10:50 AM
  4. Replies: 2
    Last Post: 02-18-2005, 10:06 AM
  5. Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1