Results 1 to 12 of 12

how to stop this loop....

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-23-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2016
    Posts
    210

    how to stop this loop....

    Hi,

    Below is my script and its not stopping once the data is over.....Please help me on this and correct me where I am going wrong

     
    Sub test()
    
    Dim row As Long
        row = 2
        
        Range("K2").Select
        
        Do
        ActiveCell.Offset(0, 1).Select
        ActiveCell.FormulaR1C1 = "=+RC[-11]"
        ActiveCell.Offset(0, -1).Select
        Selection.End(xlDown).Select
        
     Loop Until Cells(row, 3) = "Powered by GL Compliance Manager"
    
    End Sub
    Last edited by vimalanathk; 12-03-2013 at 01:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loop Does Not Stop
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2011, 07:31 PM
  2. Can't get my loop to stop!!
    By berlinhammer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2009, 03:04 AM
  3. Loop until won't stop!?
    By meacho in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2007, 03:37 PM
  4. Hot key to stop a LOOP
    By joopdog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2006, 02:51 PM
  5. Stop a loop
    By Matthew McManus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2005, 04:55 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