Thread
:
Delete row depending on size of Characters in cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Sharad
external usenet poster
Posts: 123
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!
Reply With Quote
Sharad
View Public Profile
Find all posts by Sharad