Hi Simon,

Thank you for your reply. I understand that code clears the content within the range. However, what I am looking to do is for it to automatically clear the contents within K5:K10 of the "Summary" Sheet when there are no values in the "Contact Details" Sheet.