I have the following code:

Worksheets("List Report").Range("ListRptData").Clear
If there is data in my "ListRptData" range, it clears just fine - but if the range does not contain any values, I get a debug error... so how should I rectify this?

Right now this is routine ran from a command button on a user for when a new list report is ran, however, I planned on writing code that the range will be cleared whenever the workbook is opened.