ListObject DataBodyRange Returns Object Variable Not Set Error

Hi all,

Using Excel 2010.


I would like to test a DataBodyRange of a ListObject and delete the DataBodyRange if the Rows.count >=1
My code is returning an error:

Run-time error '91':
Object variable or With block block variable not set

But I do not see a problem wi the code (Below)

thx
w

Please Login or Register  to view this content.

The DataBodyRange object is Nothing when the table has no rows, so test for that.

Please Login or Register  to view this content.

Thanks Andy,

Your code is working perfectly!

thx
w