Check if a specific ListObject exists

[Stevenn]

I try to delete a ListObject with a specific name, but get an error if the ListObject does not exists.

How can I check if the ListObject exists before I try to delete it? I've tried following

If .ListObjects(strDataListName).Exists Then
        .ListObjects(strDataListName).Delete
End If

 

[mikerickson]

You could use this instead of testing.

On Error Resume Next
.ListObjects(strDataListName).Delete
On Error Goto 0