Macro to blank out filtered columns
Solved/Closed
Related:
- Macro to blank out filtered columns
- Tweetdeck larger columns - Guide
- How to delete columns in word - Guide
- Excel online macro - Guide
- Convert multiple rows to columns in excel macro - Guide
- Excel run macro on open - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Jun 2010 à 10:47
7 Jun 2010 à 10:47
Simple .clear would work
range("M2:M" & rows.count).Clear
This will clear all visible cells in column M. Hidden cells due to filtration are not impacted
range("M2:M" & rows.count).Clear
This will clear all visible cells in column M. Hidden cells due to filtration are not impacted
7 Jun 2010 à 14:12