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.