You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • Sorry completely different question now.

    When you use VBA to apply an autofilter, and then delete the cells that are visible, do you have to click ok? I'm pretty certain i shouldn't have to, and I'm tired and at home. Is it something like turn screen updates off?

  • I don't think you do. If you do, then the code to stop it (and restart again after):

    Application.DisplayAlerts = false
    
    Application.DisplayAlerts = true
    
About

Avatar for aggi @aggi started