Delete Table Rows

[gsandy]

I have a table (tblSum) in a worksheet (Summary). In column D of the table is a field list "Type".
I wish to delete all rows in the table that have "Near Miss" in the "Type" column. The code below is not working.
Any help would be appreciated. Thanks Sandy.

Please Login or Register  to view this content.

[Marc L]

Hi !

Activate the Macro Recorder then use a filter of the table for "Near Miss" then right click and delete rows :
you will get your own free base of code !
In case of a need for optimization, post the generated code here via the appropriate icon …

[Olly]

Try this:

Please Login or Register  to view this content.

[gsandy]

Thanks Guys. Olly I used you code and it worked great. Cheers Sandy