Delete Visible Rows from Filtered Range as Table

  • Good morning,

    I've run into what seems a pretty silly issue, but can't seem to figure it out or find anything relevant on the net.

    I have a range that has been formatted as a table. Once I've applied a filter, if I try to select all of the rows, and delete the visible rows the option is greyed out.

    Is there no way, short of vba, that I can just simply delete the visible rows?

    If there is no other way, would appreciate the code that will achieve the desired result.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!