View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JOUIOUI JOUIOUI is offline
external usenet poster
 
Posts: 72
Default Deleting rows with a two criteria

I need to edit this code to delete rows if cells in column B are empty AND if
the corresponding cell in Column A is MC, Disc or Visa, is that possible?

Sub delRows()
Range("B:B").SpecialCells(xlCellTypeBlanks).Entire Row.Delete
End Sub