Steve Bayliss
New Member
- Joined
- Jan 13, 2016
- Messages
- 8
Hi Everyone,
This is an interesting problem and I think it is a bug.
I have a structured table (listobject) that has a hidden column(s).
When the table is filtered I cannot delete multiple rows. If I unhide the hidden column I can.
<tbody>
</tbody>Make sure you start in Column A
<tbody>
</tbody>
<tbody>
</tbody>
This is an interesting problem and I think it is a bug.
I have a structured table (listobject) that has a hidden column(s).
When the table is filtered I cannot delete multiple rows. If I unhide the hidden column I can.
To demonstrate the issue setup a structured table as follows: |
<tbody>
</tbody>
Column1 | Column2 | Column3 | Column4 |
bla bla | bla bla | ABC | bla bla |
bla bla | bla bla | DEF | bla bla |
bla bla | bla bla | ABC | bla bla |
bla bla | bla bla | ABC | bla bla |
bla bla | bla bla | ABC | bla bla |
<tbody>
</tbody>
To demonstrate the issue setup a structured table as follows:
<tbody> </tbody> OK in doing this post I appear to have now found a couple of workarounds... 1. Instead of selecting entire rows, select a range of cells in the table for the rows to delete then right click, delete, Entire Sheet Row... which works.. go figure. 2. Add a blank column into the worksheet so that the table starts in Column B. repeat above and you can delete multiple filtered rows with columns in the table hidden. I don't really want an additional column prior to the table and I would like to essentially do something like this in VBA after filtering to delete all rows matching a criteria... Range("Mytable").EntireRow.Delete | |||||||||||||||
Thanks Steve |
<tbody>
</tbody>