By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Delete Rows on complex condition

Code to delete rows when
  • Column M not an 'A'
  • columns (N,O,P,Q,R,U) are 0 or blank

    VBA code
  • Verify that that sheet is the correct one by checking column headers
  • Ask user before continuing
  • find the last row of the sheet
  • For each row
    • Check if above condition
    • delete the row if true
  • Display how many rows deleted
    • blog comments powered by Disqus