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

    'Clear previous data
        With ws
            Set tbl = .ListObjects("tblData")
            With tbl
                If .DataBodyRange.Rows.Count >= 1 Then
                    .DataBodyRange.Delete
                End If
            End With
        End With