Results 1 to 4 of 4

Delete Row If Contains Any Letter A-Z.

Threaded View

  1. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Delete Row If Contains Any Letter A-Z.

    Try this,

    Option Explicit
    
    Sub ParseData()
        Dim rCell            As Range
        Dim cel
        Dim x                As Range
        
    
        Application.ScreenUpdating = False
        
        With CreateObject("vbscript.regexp")
            .Global = True
               For Each rCell In Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
                .Pattern = "[a-zA-Z]"
                Set cel = .Execute(rCell)
                 Debug.Print cel.Count
                 If cel.Count <> 0 Then
                    If x Is Nothing Then
                      Set x = rCell
                    Else
                      Set x = Union(x, rCell)
                    End If
                 End If
            Next rCell
        End With
          x.EntireRow.Delete
        Application.ScreenUpdating = True
    End Sub
    Edit: Never mind nilem has sorted you out.
    Attached Files Attached Files
    Last edited by JapanDave; 08-21-2012 at 12:37 AM.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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