autofilter delete

  1. U

    VBA: Delete Rows Based on Criteria

    Hello Gurus, Good day! Could you possibly help me tweak the code below? Scenario is I have to delete the data that is below 500 including blanks and zeroes in Column E. Headers is located in Row A Sub DeleteRowIF() Dim zlr As Long zlr = ActiveSheet.UsedRange.rows.Count With Range("A2:AZ"...
    • unknownymous
    • Thread
    • autofilter delete criteria based delete a row excel & if macro macro filter
    • Replies: 3
    • Forum: Excel Questions
  2. M

    Autofilter delete and return

    I am having a problem with autofilter in vba form. I have two documents linked together and when soemthing is typed in a certain cell everything is copied over to another sheet. When that word is deleted i want it to autofilter and delete the row that was previously copied. I can seem to get it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top