Clear Range code error if range is already empty

[gheyman]

I have code to clear a named range. It works great if there is data in the range. But if the range is empty, I get an error.

I want to check to see if the named range has data before I run code (if that's the smart way).

Help Please. Not sure how to check or if I should stop macro if error

Sub ClearPBOMTable()

    Worksheets("PBOM").ListObjects("tblPBOM").DataBodyRange.Delete

End Sub

 

[RoryA]

Since it's a one-line sub, just put On Error Resume Next at the start.

 

[gheyman]

That works! Thank You.