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
- Excel vba filter column based on cell value ✓ - Forum - Excel
- Macro for blanks ✓ - Forum - Excel
- Excel go to next blank cell in column vba ✓ - Forum - Programming
- Macro copy and paste in next blank cell - Guide
1 reply
rizvisa1
Jun 7, 2010 at 10:47 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 7, 2010 at 10:47 AM
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
Jun 7, 2010 at 02:12 PM