View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jocelyn[_3_] Jocelyn[_3_] is offline
external usenet poster
 
Posts: 5
Default entirerow.delete multiple text conditions

Hi,

Total newbie question here. I'd like some help with deleting entire
rows based on multiple text conditions. In hunting around on the
group, I snagged this macro, which will work for one text condition.
How can I change it to make it select all cells on the sheet named
Sheet2, look for multiple conditions and delete rows based on all of
them in a single macro?

Sub deleteWithI()
For Each myCell In Selection
If myCell = "I" Then myCell.EntireRow.Delete
Next myCell
End Sub

TIA,
Jocelyn