Clear Data, Leave Borders

I have the following code in a worksheet:

Sub CLEAR_DATA()

Range("OT_Hours").Clear

End Sub

Is there any way of clearing the data in the range, but for it to not remove the Cell Borders?

Hi there,

Try:

Range("OT_Hours").ClearContents

Hope this helps.

Regards,

Greg M

Hi again,

Many thanks for your feedback.

Unable to give you Rep for this.

No problem, thanks for trying!

Regards,

Greg M