Results 1 to 8 of 8

Delete Unwanted Rows

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Houston, USA
    MS-Off Ver
    Excel 2010
    Posts
    21

    Delete Unwanted Rows

    Hi,

    Here's the code that I wrote to delete all the rows that not empty in column V. However, it did not work. Please help. Thanks.

    Dim LCell As Range
    Dim X As Long
    X = ActiveSheet.UsedRange.Rows.Count
    For Each LCell In Range("V2:V" & X)
            If LCell.FormularR1C1 <> "" Then
                LCell.Select
                Selection.EntireRow.Select
                Selection.Activate
                Selection.Delete Shift:=xlUp
            End If
    Next
    Best regards,

    Matt
    Attached Files Attached Files
    Last edited by mattjchen2@gmail.com; 07-08-2013 at 10:48 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