View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default Delete row depending on size of Characters in cell

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




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!