Thread
:
delete rows that don't contain text
View Single Post
#
6
Posted to microsoft.public.excel.programming
Jarek Kujawa[_2_]
external usenet poster
Posts: 896
delete rows that don't contain text
try this one:
Sub test()
For Each cell In Selection
If cell Like "*Total*" Then
cell.Rows.EntireRow.Delete
End If
Next
End Sub
Reply With Quote
Jarek Kujawa[_2_]
View Public Profile
Find all posts by Jarek Kujawa[_2_]