Multiple Sheet Clear Cells

Hi, I've had a search for what I am looking for but can't seem to find it.

I have multiple user defined cells across multiple sheets in my work book that I would like a macro to clear, in order to use the sheet from blank.

I tried doing with with record macro, but it was activating the sheets & cells and it looks very messy, I tried to remove the activate sheets & cells from the VBA, but that didn't seem to help.

Basically I want to just click a button and all required cells are cleared, no changing sheet.

I am using Excel 2010.

I tried with this VBA formula, but it's not liking it, I'm fairly sure I've coded it wrong, but what I am looking for is how to make it right.

Please Login or Register  to view this content.

All help appreciated.

Brilliant, Thank you for being so quick.