Remove Filter in Excel
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-06-17 07:51 PM
Hi everyone,
Is it posible to remove filters from an Excel worksheet? I need to clear all cell values (everything but headers) and the workshet is filtered, so when I use the "Clear content" action only clear those rows that are visible.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-06-17 09:20 PM
Are you using code stages to manipulate the worksheet? If so you could use something along the lines of:
ActiveSheet.AutoFilterMode = False
