Macro to clean empty cells
 

As I have had some great help from this group before, here is another
request.

Am looking to clean up some sheets in various workbooks in Excel 2007
Anybody able to help me out with a macro that will look for empty cells and
then clear them out of all formats or hidden characters etc. that they may
have but cant be seen.

Will only need to run it on individual named sheets rather than on whole
workbook

many thanks