Results 1 to 2 of 2

code stops working after X rows.

Threaded View

Guest code stops working after X... 11-23-2008, 02:37 PM
VBA Noob colwyn, Please add the... 11-23-2008, 03:14 PM
  1. #1
    colwyn
    Guest

    code stops working after X rows.

    I'm using Excel 2007 and my s/s is 360000 rows deep.
    To cut+paste formulas+formats from one column to another I'm using the following code:

    Sub move_formula_and_formats_from_I_to_L()
    
    Dim cell As Range
    
    Application.ScreenUpdating = False
    
    
    For Each cell In Range("I1", Cells(Rows.Count, "I").End(xlUp))
    With cell
    If .HasFormula And Not .Offset(1).HasFormula Then
    .Cut Destination:=.Offset(1, 3)
    End If
    End With
    Next cell
    
    Application.ScreenUpdating = True
    
    End Sub
    Each time the code is run it stops working after 159050 rows and highlights (in yellow) the line:
    .Cut Destination:=.Offset(1, 3)
    Can anyone help with this??

    Small XML attachment may help better understand.
    Big thanks.
    Colwyn.

    cross-post: http://www.mrexcel.com/forum/showthread.php?t=355116
    Last edited by colwyn; 11-24-2008 at 01:14 PM. Reason: Added code tags as per forum rules

Thread Information

Users Browsing this Thread

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

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