Results 1 to 2 of 2

Delete Entire Rows

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2006
    Posts
    10

    Delete Entire Rows

    I know I was a pain in the *** earlier, but this time I'll try to be easy. Can you tell me why this keeps coming back to say "No cells were found"?

    I only have like 5 rows that have data in Column H, and all the rest of the rows should be deleted as per the red text part of my quote, right? Why isn't it working?

    Sheets("Survey").Select
    Sheets("Survey").Copy After:=Sheets(1)
    Sheets("Survey (2)").Select
    Sheets("Survey (2)").Name = "Notes"
    Range("A:J").Sort Key1:=Range("H1"), Order1:=xlDescending, Header:= _
    xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
    DataOption1:=xlSortNormal
    Columns("H:H").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
    Selection.Delete Shift:=xlUp
    End Sub
    Thanks again in advance!

    Delete this thread. I just discovered that my so-called "blank" cells actually all have a space in them.

    So now I have to figure that out.
    Last edited by razorangel; 12-19-2006 at 06:45 PM.

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