Delete Row from Table

[ManUBlueJay]

I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell.
In the past I have used this simple code "Range("MyRange").EntireRow.Delete"

This does not work today in Excel 2016

 

[Fluff]

Just tried it with that type of formula & everything works for me.
Does this work

With Range("myrange").ListObject
   Intersect(Range("myrange").EntireRow, .DataBodyRange).Delete
End With

 

[ManUBlueJay]

Bingo!! Perfect. Thank you for your perseverance
I am tempted to rebuild this file starting with Excel 2016. It is probably somehow corrupted.

 

[Fluff]

It may just be that something has changed between 2016 & 365, that enables deleting of entire rows within tables.

 

[ManUBlueJay]

Like I mentioned in my first post. I have used this exact same line in other tables.
This has been my standard way using a named range to identify the cell and then deleting the entire row.
That's why it is frustrating that it all of a sudden doesn't work, but I don't know enough to figure it out.

 

[Fluff]

It's possible that something on that sheet has been corrupted & wouldn't hurt to rebuild it.