ok thank you for the hint there, thought i was doing something wrong to be honest. So what ive done is copied and pasted that same code to the workbook open and workbook before close, so now it clears those cells when i open and close excel. This will be good enough for me now i reckon, so thank you so much for your time on this.

Regards,

Andrew