Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Macro to blank out filtered columns [Solved/Closed]

Report
-
 kat -
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

Answer 1 / 1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 767
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
Report

Thanks so much - just what i was looking for.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!