Results 1 to 5 of 5

Run time error 1004 when adding rows

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    Run time error 1004 when adding rows

    Hi,

    I have the following code, called from a Userform:

    Dim r As Integer
        r = ActiveCell.Row
        ActiveCell.EntireRow.Insert
        Sheet5.Cells(r, 1).EntireRow.Insert
    Sheet1 that I run it on goes to column IR leaving 4 blank columns. Sheet5 runs to IQ leaving 5 blank columns. I only have about 100 runs of data.

    Any ideas would be greatly appreciated.
    Last edited by jpruffle; 09-28-2009 at 07:35 AM.

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