Macro to blank out filtered columns

Solved/Closed
kat - Jun 7, 2010 at 10:03 AM
 kat - Jun 7, 2010 at 02:12 PM
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!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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
0
Thanks so much - just what i was looking for.
0