(Solved) – In Column “A” I am trying to delete all variables that begin with a number

(solved)-–-in-column-“a”-i-am-trying-to-delete-all-variables-that-begin-with-a-number

In Column “A” I am trying to delete all variables that begin with a number. So for example, in the image that I have posted, I want my macro to delete cell # 3 & 11.

  Sub RemoveNumbersFromColumnA()
  Dim X As Long, R As Long, Data As Variant
  Data = Range("A3", Cells(Rows.Count, "A").End(xlUp))
  For R = 3 To UBound(Data)
    For X = 3 To Len(Data(R, 3))
      If Mid(Data(R, 3), X, 3) Like "[0-9]" Then

      Rows("3:" & cell.Row - 1).Delete
Next
      Range("A3").Resize(UBound(Data)) = Data
Else if
End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *