Macro to blank out filtered columns
[Solved/Closed]
Related:
- Macro to blank out filtered columns
- Macro to find last blank cell in column ✓ - Forum - Excel
- Vba first blank cell in column - How-To - Excel
- Macro for blanks ✓ - Forum - Excel
- Excel vba filter column based on cell value ✓ - Forum - Excel
- Macro copy and paste in next blank cell - How-To - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
Report
kat
Thanks so much - just what i was looking for.
