Delete row depending on size of Characters in cell

[Guest]

Hello everyone ,

I would like to delete an entire row if a cell on the same row has more
then x amount of characters. I would need this to loop down the entire
spreedsheet. Is this possible ?
Hint: Normally (10 out of 10) the cell its looking for will in the first col

Example: If cell A:109 has more then 40 characters delete row 109

Thank you in advance,
Carl

 

[Sharad]

Sub delRows()
For Each c In Worksheets("Sheet1").UsedRange.Cells
If Len(c.Value) > 10 Then
c.EntireRow.Delete
End If
Next c
End Sub

 

[Guest]

Thank you Sharad
you really helped me
Carl