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
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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?