Results 1 to 3 of 3

Delete rows if column contains a blank code included

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    5

    Delete rows if column contains a blank code included

    Hello I need help filling out this macro that i've pulled from another thread.
    And here is the code

    Sub delete_rows_blank()
     
    On Error GoTo End
     
    [BE3:BE14204 ].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
     
    End:
     
    End Sub
    My row is BE3:BE14204 That way if there is a blank within that range (column range) it deletes the entire row. I keep getting a syntax error, what is going wrong?

    The debugger highlights the first part "Sub delete_rows_blank()"
    Last edited by v3x0rg; 10-11-2010 at 10:04 AM. Reason: changedm macro

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