Linked Questions

Popular Questions

Apply filter box using conditional formatting

Asked by At

I have a sheet with the basic Excel filter enabled on the top row (the one under Sort and Filter on the ribbon).

When I run a VBA procedure, it clears the data on this sheet and replaces it with new data. This also removes the filter.

Is there a way I can apply this simple filter drop-down option using VBA by applying it to a range, or conditional formatting?

Related Questions