Macro to blank out filtered columns
Solved/Closed
Hello,
I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can you help with the macro code?
Thank you!
I have a worksheet that is filtered by a number. I would like to blank out columns M, N, S and T. (Only the filtered information) Can you help with the macro code?
Thank you!
Related:
- Macro to blank out filtered columns
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- Spell number in excel without macro - Guide
- How to delete columns in word - Guide
- Excel macro to create new sheet based on value in cells - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 10:47 AM
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